I doubt that it will or should. Handling text direction and mixed direction text is an application issue. It helps if you're using Unicode.
-- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 ________________________________________ From: IBM Mainframe Discussion List <[email protected]> on behalf of ITschak Mugzach <[email protected]> Sent: Tuesday, January 9, 2018 1:17 AM To: [email protected] Subject: Re: Transferring hebrew data from Db2 Z/OS to PC I wonder how will it solve the Hebrew reading direction issue... ITschak בתאריך 9 בינו׳ 2018 7:51 לפנה״צ, "Timothy Sipples" <[email protected]> כתב: > OK, first comment: why the **** are you FTP'ing data in the first place? > This isn't 1989 any more. :-) And this is a serious question. It's > increasingly expensive and fraught with security risks to copy data > wantonly. What's this PC going to do with a bulk, point-in-time dump of all > this data? > > Now, trying to answer your question directly (and perhaps at your own > peril): > > 1. I see in DB2-L that Kai Stroh already suggested checking your UNLOAD > options. That's a good suggestion. > > 2. You can very likely use an ETL/ELT tool that specializes in this sort of > work, notably IBM InfoSphere DataStage (preferably running on the IBM Z > machine itself). InfoSphere DataStage Version 11.7 was released in > December, 2017. > > 3. The Db2 cross-loader function is another possible option, as a part of > the data journey anyway. You would set up a Db2 instance on the target > platform (such as on the IBM Z machine itself, with Db2 for Linux), and > you'd use the cross-loader function, with Db2 for z/OS as the input and Db2 > on the other machine as the target. If any encoding scheme conversion is > required, the cross-loader should handle it. You can find some more > information on the cross-loader here (Db2 for z/OS Version 12 assumed): > > https://secure-web.cisco.com/1--F8HIjiCULhGKNjMsf9MQZU8RREUUauEHkxqe6TduwxfF_zVDIRgSuwkBZcObJm7hchby8X92tQNfiT-hfhB6LM5qHtfdZBw_BSZXdzHD5gdxgV5DtcHwlr2xBqz7-tOoGOB5UtJx_ElBG75OCmoraH4iCcbfn9zix8hw1PJfuXjIf_Te94FK1-9IocxIjl_Pe319NUg6zQZV5eJqPN2veJKgn9Bf-Iykig9eJgJ3R6PPXIsWmgXDgGWZwU3s9eJwF71cDs8edINFIDET4-jnxerRKxsecrfgvfxmKjPEA7mfK_euKRYSrdPN0dRrUC5HrN9Sc_B08ZvEmNU2h28iqJaumpyyZZ9_dqQU80CVPwwX1QA_lVxd2RRQ2BSNRK0OR5q9UzbZmBMoPNRXH8mCKDF0NOzqAnhPqb2w-UWMU3NVOBmBQeQyv2z_5eRPol/https%3A%2F%2Fwww.ibm.com%2Fsupport%2Fknowledgecenter%2Fen%2FSSEPEK_12. > 0.0/ugref/src/tpc/db2z_loadusecrossloaderfunction.html > > 4. Db2 High Performance Unload for z/OS might add some value here. The > latest version is 5.1 as I write this. > > 5. One more try per the first comment: just access the data (more securely) > using Db2 for z/OS native RESTful interfaces (HTTPS instead of FTP). See > here for details, in brief: > > http://secure-web.cisco.com/1IUTaAXyZp3nLassn5SoM3yRT520QJQI6ffVu_E1fZQ_bdZvikhJFVYvLUmkZZRruPeMNYY5JQzsbiR8ewXPTgKHFjJsefEWPGIq5gowsT-OYqJVQLa1IkQajF3yFOL7bgqeGcmWVQNJx5pY-OqamyR0mc1NtS5G84mZqBPWLLdG-JDmkXRhA3SieiVzeFD6AS2KNxmM0KLe8-mYpshQyeZjlC9yUq_-Lbjt56Y7tcOjnupsAp1dco_y9V2CPtv55s3F3Ksio3Yo8kvvsyhVgp0O3dCKqdWyNaFrt2cR-_wXuPEGpAZU1xB3bIqU4xiuqeLuIA5-rgnSMLQz_zRxdB7ej9rD3Zw1W3WdWIFYsRfcIbMK6zAMeTAJEZdevs5agj8FF2iVAwe8httYkrG40gkCq0zPokl19jcRSb_4k3uj-oIKbSNA5155xLrrJmJAT/http%3A%2F%2Fwww.idug.org%2Fp%2Fbl%2Fet%2Fblogid%3D477%26blogaid%3D544 > > http://db2geek.triton.co.uk/db2-native-rest-api-getting-started/ > > ------------------------------------------------------------ > -------------------------------------------- > Timothy Sipples > IT Architect Executive, Industry Solutions, IBM Z and LinuxONE, AP/GCG/MEA > E-Mail: [email protected] > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
