Transferring hebrew data from Db2 Z/OS to PC

Yaron Tal

Transferring hebrew data from Db2 Z/OS to PC

Hi everyone,

I am trying to move large amounts of data from Db2 Z/OS to other platforms.

This is done by running UNLOAD utility to prepare a file and then FTP

the file to my PC in order to LOAD it later onto another platform.

File has a mix of fields - integers, decimals and characater data which includes hebrew, english

and special characters like : " , ( .

Problem is - hebrew data gets reversed (left to right ordering) in the process.

I am using BlueZone FTP by Rocket Software which is quite fast (we're talking about large amounts).

IBM Personal Communications emulation moes the data in right order (using BIDI options - implicit ordering)

but is very slow and might take weeks for the entire set of data to be moved.

Will appreciate your help on how to get the hebrew on the right direction using normal FTP process, Thanks!

Lizette Koehler

Transferring hebrew data from Db2 Z/OS to PC
(in response to Yaron Tal)
When it comes to transferring data the IBM Main list may be the better place to ask



To join, if you have not done it, use this URL



General MVS IBM-Main https://listserv.ua.edu/archives/ibm-main.html



Or use this to send the sign up to the List Server





For IBM-MAIN subscribe / signoff / archive access instructions, send email to [login to unmask email] <mailto:[login to unmask email]> with the message: INFO IBM-MAIN







Lizette





From: Yaron Tal [mailto:[login to unmask email]
Sent: Sunday, January 07, 2018 2:57 AM
To: [login to unmask email]
Subject: [DB2-L] - Transferring hebrew data from Db2 Z/OS to PC



Hi everyone,

I am trying to move large amounts of data from Db2 Z/OS to other platforms.

This is done by running UNLOAD utility to prepare a file and then FTP

the file to my PC in order to LOAD it later onto another platform.

File has a mix of fields - integers, decimals and characater data which includes hebrew, english

and special characters like : " , ( .

Problem is - hebrew data gets reversed (left to right ordering) in the process.

I am using BlueZone FTP by Rocket Software which is quite fast (we're talking about large amounts).

IBM Personal Communications emulation moes the data in right order (using BIDI options - implicit ordering)

but is very slow and might take weeks for the entire set of data to be moved.

Will appreciate your help on how to get the hebrew on the right direction using normal FTP process, Thanks!



-----End Original Message-----

Kai Stroh

RE: Transferring hebrew data from Db2 Z/OS to PC
(in response to Yaron Tal)

What options do you use for the UNLOAD utility? (E.g., do you specify DELIMITED, or UNICODE CCSID(...)?)

This affects how the data is stored in the flat flies. I have not tried it, but UTF-8, a.k.a. CCSID 1208, should be able to represent all possible characters and handle RTL text correctly. I would not use DELIMITED format if columns can contain binary data, which includes line breaks, because that can mess up the resulting flat file.

When transferring the SYSREC data sets to a PC using FTP, I'd avoid ASCII mode and use binary mode with record structure or block mode instead. You will have to process the data on the PC before loading it into a different RDBMS because it will have the internal format that Db2 for z/OS uses, but that is something a Java program can do. The record structure format is very easy to parse, block mode is more complicated but might be necessary if you want to transfer VBS data sets correctly to a PC.