• Subject: FTP'ing a file from AS400 to UNIX
  • From: bvining@xxxxxxxxxxxx
  • Date: Fri, 15 May 98 10:02:06 CDT

Need a bit more information to be able to determine what is going on.
On the AS/400, assuming we are talking about a physical file, do a
DSPFD against the file and determine what the CCSID is.  Also do a
DSPPFM against the file, find a record with the pipe, and then use F10
to view the hex value of the character.

Depending on the CCSID of the file, you should find:

   CCSID  37 - x'4F'
   CCSID 185 - x'4F'
   CCSID 500 - x'BB'
   (for other CCSIDs, see the International Application Development book)

Please let us know what CCSID and code point you find.

I'm not familiar with Oracle, but on the UNIX system please do the
equivalent.  That is, find what code page the Oracle file is supposed
to be in, and what code point is actually being used.  If the code page
is 819 (ISO 8859-1) the pipe should be x'7C' and the & x'26'.

Finally what FTP parameters are being specified, what FTP subcommands,
and what is your jobs CCSID?

Bruce Vining

>The character being converted is as follows
> | (pipe) into &
>The pipe is used as a delimiter in a plain text file transferred to an
>oracle database nightly.

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@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

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].