ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Copy to .csv an .txt into IFS directory some DB2 files with CCSID=*hex

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Copy to .csv an .txt into IFS directory some DB2 files with CCSID=*hex

    Hello, please tell me what is the right setup to copy some DB2 files into streamfiles in order to be correct processed after the transfer of those files on other systems? I need to send some DB2 files, under sftp, and on the remote server they must be interpreted as .csv and some others as .txt
    I do the copy into IFS location, as streamfile using *PCASCII at codpag, but it seems I have some issues with the encoding of the file after the transfer, for the DB2 files which have *HEX as CCSID. What I have to do in the setup to be used by CPYTOIMPF?

    I tried to copy that DB2 files which have *HEX CCSID with FROMCCSID and TOCCSID parameter from CPYTOIMPF equal to *File and STMFCCSID and STMFCODPAG equal to *STMF, the defaults settings, but I still have issues with the data, its not well interpreted.

  • #2
    Have you tried changing the FROMCCSID parameter to the appropriate value instead of leaving it as the default?

    Comment

    Working...
    X