FTP

0 pts.
Tags:
DB2 Universal Database
When I transfer a file (FTP) from one system to another using Get command numeric data comes as junk. Does anyone know how I can retrieve numeric data ? Thanks
ASKED: March 15, 2006  11:25 AM
UPDATED: March 20, 2006  10:18 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

FTP is only for text data. it’s yoour job to give to ftp a transferable file, ie no binary data (such as packed numeric or integer or float or …).
Or uses BIN mode to transfer data

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • EDI4Colorado
    If your target system is PC based then you might need to specify the ASCII mode for the transfer.
    0 pointsBadges:
    report
  • Pcatlin
    The key issue is packed fields. No matter if you specify binary or ascii, FTP will not interpret any file contents, it will just transfer it as is. You will need to do some work on the iSeries to un-pack the fields before sending via FTP. If you don't have negative numbers, you can either change the DDS of the original file to specify "S" type numeric fields, create a second file with "S" numeric fields and copy (*MAP) into it or perhaps you can use the CPYTOSTMF command to create an IFS file and send that via FTP instead (make sure you issue "quote site namefmt 1" from remote system to access the IFS).
    200 pointsBadges:
    report
  • JohnDavid
    Hi, You might find your source file with a CCSID that translates wrong when FTPing it another platform. Best regards JohnDavid
    5 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following