Ask the Expert

File transfer DTF "hooks"

For one of my customers, I need to implement a file transfer from iSeries to a Windows box. The file to transfer, contains Polish characters, but also ^ as field separator.

The transfer method we use is DTF client access.

We tried different settings in client access DTF but none of them gave correct result. Can someone, who experienced a similar problem, give me a hint? iSeries settings are: SYSVAL QCHRID = 697 - 37, QCCSID = 37. Thanks a lot in advance

File transfer is doing convertions on the following "hooks":
  • If the user profile CCSID (i.e the job CCSID) is different from the CCSID of the target file character conversion is occuring on the AS400 itself. Make sure your database file is defined with Polish CCSID and that the user is using the same CCSID.
  • The Windows box uses the national setting to perform character conversion from EBCDIC to ASCII. Make sure your Windows regional setting are set to Polish.

This was first published in July 2008

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

Forgot Password?

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

Your password has been sent to: