Re: RE: File Tranfers

[John Cirocco <JCirocco@xxxxxxxxxx>]

Randy,

Unfortunately it is an existing interface to an SQL server an the field we are 
adding is a 10 character field that may or may not be used and/or filled 
entirely.  Rearrainging fields would make the task too large.  I was kinda 
hoping that a different transfer option that I did not know about would do the 
trick.  I am not an SQL server developer but I think they are getting a data 
base error similar too a decimal data error.  What I think we will do is force 
a constant as the last field and be done with it.

Thanks for the help!

John


>>> "Randy Robb" <rwrobb@pbsilink.com> 04/20 4:26 PM >>>
John,
  Since AS400 works with EBCDIC fixed length records and PC's work with
ASCII variable length records, I've always seen problems transferring files
with trialing blanks.
  My solution has been to select the fields I want in such a way that the
last field is never blank.  Address files usually have State as non-blank,
so I put that last.  Surely, you can sequence the fields in such a way as
well. No?

                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---