Hi Charles,
Thank you for writing. I issued the command, here are the results:
ENVIRONMENT: CREATED 04/22/2006 AT 23.04.55
MODIFIED 04/22/2006 AT 23.09.38
IMAGE CREATED 08/05/2003 AT 10.03.23
SERVICE: CHARACTER NORMALIZATION CASE
STORAGE: ACTIVE 9862 PAGES
LIMIT 25600 PAGES
CASECONV: NONE
NORMSERV: DISABLED
CONVERSION: 00037-01200-ER 01200-00037-ER
00037-01208-ER 01208-00037-ER
00037-00367-ER 00367-00037-ER
00256-01200-ER 01200-00256-ER
00256-01208-ER 01208-00256-ER
00256-00367-ER 00367-00256-ER
The conversion table went on for quite a while....
The datafile is created using SQL query, DSNTIAUL unload program, and I
have the
data in a display format, no decimal data. I am able to use the DB2
UNLOAD utility
but I was hoping that I didn't have to run the results of the query
(multiple tables)
back in to a DB2 table to unload it in unicode format.
Dave
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Charles Mills
Sent: Friday, September 01, 2006 11:45 AM
To: [email protected]
Subject: Re: Converting data into Unicode
I'm not really an expert but seeing as how you haven't gotten any other
answers, and I have one or two z/OS Unicode scars, I'll take a stab at
this.
Your second question first - sure there are lots of other ways to
convert to Unicode. One obvious way - Enterprise COBOL has extensive
Unicode support now.
I don't *know* if FTP uses the z/OS Unicode translation facilities but I
am going to guess it does. Do you have the proper Unicode tables built
and installed? What does a D UNI,ALL console command show?
Your input dataset is named '...UNLOAD'. If it is an IEBCOPY or TSO
TRANSMIT unload dataset I don't think it will survive translation to
Unicode because it would include non-character data, and non-character
data suffers badly during any character set conversion. Perhaps I am
reading too much into the name and your source dataset is pure EBCDIC
character data.
Charles
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Dave Schaeffer
Sent: Thursday, August 31, 2006 6:29 PM
To: [email protected]
Subject: Converting data into Unicode
Hello,
I've been tasked with creating Unicode files from a z/OS 1.4 machine
and FTPing them to a Unix server. I have tried issuing a FTP with UCs2
subcommand and I keep getting a 40500 return code. This is the FTP
commands I'm
issuing:
[ip address]
[user id]
[password]
PWD
UCs2
PUT 'DBXP.SDB2P.PARTTAB.UNLOAD' test.part.unicode.txt
CLOSE
QUIT
Can anyone see what I might be doing wrong? Is there another was to
convert the data into Unicode?
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send
email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search
the archives at http://bama.ua.edu/archives/ibm-main.html
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
