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

Do you have translate binary=true; on your AS400 JDBC URL?

"jdbc:as400://" + AS400NAME + "; naming=system;translate binary=true;";

Kristen



> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Anand, Rajesh
> Sent: Thursday, September 08, 2005 11:05 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: 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.
> 
> -- 
> 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.
> 
> 
> -- 
> 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.
> 
> 
> -- 
> 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.
> 
> 
>