EBCDIC to ASCII --part3--
EBCDIC to ASCII --part3--
This is a topic for an orphaned message.
Hi.
Ive got the mainframe file, and the values are in packed decimal.
Do I change the EBCDIC to ASCII and then apply unpacked decimal? Is this possible? Or will it only work if I get the EBCDIC file with the values that are in unpacked decimal after the convert?
Pieter
-----Original Message-----
From: Hendrik Kotze [mailto:hendrik.kotze@ascentialsoftware.com]
Sent: Thursday, October 11, 2001 1:18 PM
To: pbrundyn@metropolitan.co.za
Subject: RE: EBCDIC to ASCII --part2--
When you use a mainframe file you set your type of line termination to none. You have to enter the metadata or import the Cobol copybook and use fixed column width as the format type. Datastage will then use the metadata to look at the data and that will make sense. Be careful of the packed fields. If the file was generated on the mainframe and extracted and converted to EBCDIC make sure that the packed fields was unpacked as the binary value in the packed field cannot be converted in packed format, it must be unpacked and then formatted.
-----Original Message-----
From: Brundyn, Pieter [mailto:pbrundyn@metropolitan.co.za]
Sent: Thursday, October 11, 2001 13:05 PM
To: datastage-users@oliver.com
Subject: EBCDIC to ASCII --part2--
Ok.
It seems to be converting the EBCDIC to ASCII but there are the following
problems:
- Do you use the sequential file !?! The mainframe EBCDIC file is binary.
- When do you know when the next row starts?
I created the job like this:
[[[MAINFRAME_FILE(ebcdic)]]] ----> [TRANSFORMER] -----> [[OUTPUT_FILE(ascii)]]
In the transformer I have the following :
TheString Varchar 5000 -------------------->
ASCII(OUTPUT_FILE.TheString1)
I can look at the data, but not everything looks right!?
Any suggestions... ?
Pieter
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, October 11, 2001 12:13 PM
To: datastage-users@oliver.com
Subject: RE: EBCDIC to ASCII
There are two complementary functions.
ASCII(x) will convert from EBCDIC to ASCII.
EBCDIC(x) will convert from ASCII to EBCDIC.
HOWEVER-----
Beware that there is more than one variant of EBCDIC. (This is particularly true in Japan.)
-----Original Message-----
From: Brundyn, Pieter [mailto:pbrundyn@metropolitan.co.za]
Sent: Thursday, 11 October 2001 19:38
To: datastage-users@oliver.com
Subject: EBCDIC to ASCII
Is there a function in datastage that will convert EBCDIC to ASCII !?
thanks
pieter
NOTICE:
This message contains privileged and confidential information intended only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not accept liability for any personal views expressed in this message.
NOTICE:
This message contains privileged and confidential information intended only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not accept liability for any personal views expressed in this message.
NOTICE:
This message contains privileged and confidential information intended
only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not accept liability for any personal views expressed in this message.
Ive got the mainframe file, and the values are in packed decimal.
Do I change the EBCDIC to ASCII and then apply unpacked decimal? Is this possible? Or will it only work if I get the EBCDIC file with the values that are in unpacked decimal after the convert?
Pieter
-----Original Message-----
From: Hendrik Kotze [mailto:hendrik.kotze@ascentialsoftware.com]
Sent: Thursday, October 11, 2001 1:18 PM
To: pbrundyn@metropolitan.co.za
Subject: RE: EBCDIC to ASCII --part2--
When you use a mainframe file you set your type of line termination to none. You have to enter the metadata or import the Cobol copybook and use fixed column width as the format type. Datastage will then use the metadata to look at the data and that will make sense. Be careful of the packed fields. If the file was generated on the mainframe and extracted and converted to EBCDIC make sure that the packed fields was unpacked as the binary value in the packed field cannot be converted in packed format, it must be unpacked and then formatted.
-----Original Message-----
From: Brundyn, Pieter [mailto:pbrundyn@metropolitan.co.za]
Sent: Thursday, October 11, 2001 13:05 PM
To: datastage-users@oliver.com
Subject: EBCDIC to ASCII --part2--
Ok.
It seems to be converting the EBCDIC to ASCII but there are the following
problems:
- Do you use the sequential file !?! The mainframe EBCDIC file is binary.
- When do you know when the next row starts?
I created the job like this:
[[[MAINFRAME_FILE(ebcdic)]]] ----> [TRANSFORMER] -----> [[OUTPUT_FILE(ascii)]]
In the transformer I have the following :
TheString Varchar 5000 -------------------->
ASCII(OUTPUT_FILE.TheString1)
I can look at the data, but not everything looks right!?
Any suggestions... ?
Pieter
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, October 11, 2001 12:13 PM
To: datastage-users@oliver.com
Subject: RE: EBCDIC to ASCII
There are two complementary functions.
ASCII(x) will convert from EBCDIC to ASCII.
EBCDIC(x) will convert from ASCII to EBCDIC.
HOWEVER-----
Beware that there is more than one variant of EBCDIC. (This is particularly true in Japan.)
-----Original Message-----
From: Brundyn, Pieter [mailto:pbrundyn@metropolitan.co.za]
Sent: Thursday, 11 October 2001 19:38
To: datastage-users@oliver.com
Subject: EBCDIC to ASCII
Is there a function in datastage that will convert EBCDIC to ASCII !?
thanks
pieter
NOTICE:
This message contains privileged and confidential information intended only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not accept liability for any personal views expressed in this message.
NOTICE:
This message contains privileged and confidential information intended only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not accept liability for any personal views expressed in this message.
NOTICE:
This message contains privileged and confidential information intended
only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not accept liability for any personal views expressed in this message.