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

This is not working either.

        There is got to be a way of doing this.

        The Unicode characters in the stringbuffer such as
('00299........1112') must be able to convert in the sql but it
        doesn't.

        I've also tried creating AS400TEXT object and used toBytes
method to convert from String to AS400TEXT but the sql
        only inserts garbage this time.

        Don't know what else I could try.

        Is it possible to insert or replace AS400TEXT object similar to
stringbuffer.

        I can't see any methods though for AS400Text.

        More help needed.

        regards,
        

Rajesh Anand
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Kristen Henry
Sent: 08 September 2005 19:24
To: 'Java Programming on and around the iSeries / AS400'
Subject: 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.
> 
> 
>