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

        Anyone got any ideas or has come across this.

        Help needed urgently.

Rajesh Anand
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Anand, Rajesh
Sent: 08 September 2005 15:10
To: Java Programming on and around the iSeries / AS400
Subject: RE: Why HEX values instead of blanks in AS400 flat file


        Nope, does not allow null values.

        Its just a flat file.

        
Rajesh Anand
Mob: + (44) (0) 7947273151
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
michael@xxxxxxxxxxxxxxxxxx
Sent: 08 September 2005 15:04
To: Java Programming on and around the iSeries / AS400
Subject: RE: Why HEX values instead of blanks in AS400 flat file


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.