How to … transfer DECIMAL (packed) data between platforms (Unix ->z/OS)

Schlagwörter: 

Ansicht von 2 Beiträgen - 1 bis 2 (von insgesamt 2)
  • Author
    Posts
  • 25. Juli 2014 um 9:49 Uhr #6496

    Gernot
    Administrator

    Hi folks,

    we need to transfer data from Unix platform to z/OS. Data contains DECIMAL packed, INTEGER and text data (with umlauts). Direct connection from/to DB2 databases is not possible, so data have to be transported via simple file transfer.

    Does anyone has an idea of how to manage this problem?

    We’ve already checked-out some options:

    • FTP with SBDATACONN=(IBM-273,ISO8859-1): does not help, because DECIMAL data gets corrupted due to codepage translation.
    • FTP with BIN / IMAGE option: does not help, since text data gets corrupted due to codepage translation. This could be fixed by using a new DFSORT TRANSlate option, which allows translation TRAN=ATOE (ascci to ebcdic and vice versa) column-wise. But this requires additional work and deep knowledge of structures trasfered.
    • IBM provides a tool, called EDCICONV at z/OS and iconv at USS and AIX, but these tools translate record-wise, so corrupting DECIMAL/INTEGER/… data.

    Any idea appreciated!

    Gernot

    31. Juli 2014 um 12:38 Uhr #6519

    Gernot
    Administrator

    Another option/work-around is first to load into a DB2 for z/OS table and then externalize/UNLOAD/DNSTIAUL the data again. DB2 differentiates between internal and external data formats (text). So, it protects decimal/integer/date/time/timestamp/… data for being translated.

    LOAD INTO
TABLE ...
ASCII CODEPAGE(1252,0,0)
  • Author
    Posts
Ansicht von 2 Beiträgen - 1 bis 2 (von insgesamt 2)

You must be logged in to reply to this topic.