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

Try with a PreparedStatement.

Anand, Rajesh wrote:

>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.
>>
>>
>>
>>    
>>
>
>
>  
>