RE: Why HEX values instead of blanks in AS400 flat file

[michael@xxxxxxxxxxxxxxxxxx]

Does the table allow nulls for the columns and the column isn't getting
a value?

> -------- Original Message --------
> Subject: Why HEX values instead of blanks in AS400 flat file
> From: "Anand, Rajesh" <Rajesh_Anand@xxxxxx>
> Date: Thu, September 08, 2005 9:54 am
> To: <java400-l@xxxxxxxxxxxx>
> 
> Hi Folks,
> 
>       Further to my earlier post.
> 
>       I can see the file is being updated by this sql...even though
> I've Function Sequence error.
> 
>       insert into OCCTKFUT values ('95100299      C    PQ    200508
> 2005-08-03                   
>       FIN   0FIN20                              100     FMTM-600')  
> 
>       However where there are blanks, they appear as hex x'00' instead
> of blanks.
> 
>       WHY?? And how can I replace hex'00' with blanks in the sql
> string.
> 
>       Thanks,          
> 
> Rajesh Anand
> Merrill Lynch
> Mob: + (44) (0) 7947273151
> Email:Rajesh_anand@xxxxxx
> --------------------------------------------------------
> 
> If you are not an intended recipient of this e-mail, please notify the 
> sender, delete it and do not read, act upon, print, disclose, copy, retain or 
> redistribute it. Click here for important additional terms relating to this 
> e-mail.     http://www.ml.com/email_terms/
> --------------------------------------------------------
> -- 
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.