You have two issue to resolve: 1. Translate the data from EBCDIC to ASCII. This is the easy one. 2. The data on z/OS is probably stored visually. The last in the word is stored first. In windows, the data is usually stored logically. The first letter of the word is stored first. translating from logical to visual to not a simple matter, especially if you have numbers and special symbols in the data, for example, an address.
Does the QMF for workstation have a way to specify the translation table? Gadi -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Jose Munoz Sent: Thursday, December 03, 2015 8:30 AM To: [email protected] Subject: QMF for Workstation accessing DB2 for z/OS Dear all, Someone has experience using QMF for workstation and accessing to DB2 for z/OS with Arabic data? When I use QMF on TSO the Arabic data shows fine but when I run the same query on QMF for workstation, the Arabic data no show as it is, it is wrong totally wrong. QMF for workstation is using DRDA to access DB2 for z/OS V10. Sorry to post this subject here... -- Regards Jose Munoz Senior IT Architect (+965) 99925167 Kuwait ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN לשימת לבך, בהתאם לנהלי חברת מלם מערכות בע"מ ו/או כל חברת בת ו/או חברה קשורה שלה (להלן : "החברה") וזכויות החתימה בהן, כל הצעה, התחייבות או מצג מטעם החברה, מחייבים מסמך נפרד וחתום על ידי מורשי החתימה של החברה, הנושא את לוגו החברה או שמה המודפס ובצירוף חותמת החברה. בהעדר מסמך כאמור (לרבות מסמך סרוק) המצורף להודעת דואר אלקטרוני זאת, אין לראות באמור בהודעה אלא משום טיוטה לדיון, ואין להסתמך עליה לביצוע פעולה עסקית או משפטית כלשהי. Please note that in accordance with Malam and/or its subsidiaries (hereinafter : "Malam") regulations and signatory rights, no offer, agreement, concession or representation is binding on the Malam, unless accompanied by a duly signed separate document (or a scanned version thereof), affixed with the Malam seal. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
