Page 1 of 1
EBCDIC to ASCII converion mapping
Posted: Mon Sep 19, 2005 3:50 pm
by dsx
Any idea where to find the EBCDIC to ASCII conversion mapping used by DataStage ?
Appreciate your input.
Posted: Mon Sep 19, 2005 4:27 pm
by ray.wurlod
In the manuals and sometimes in the on-line help for any stage type that can handle it. For example, the CFF stage and FTP stage can do this kind of conversion. There is some capacity in other stage types. Why not use Adobe Acrobat's search capability?
Posted: Tue Sep 20, 2005 12:24 am
by cmmurari
you may try to use Basic functions ASCII or EDCDEIC converison function to Converts the values of characters in a string from ASCII to EBCDIC format or EBCDIC to ASCII format
cheers
krish
Posted: Tue Sep 20, 2005 1:09 am
by ray.wurlod
As a general rule, BASIC functions aren't available efficiently in parallel jobs.
Posted: Fri Sep 30, 2005 3:08 pm
by bcarlson
Not sure, but dsx may be looking for documentation that show what the actual codeset is - that is, the codeset that says that EBCDIC value A maps to ASCII value B. For example, a common codeset is ISO 8859 Latin 1, used by Oracle and Teradata.
There is more than one 'standard' mapping from EBCDIC to ASCII, unfortunately. Does anyone know how to determine what DataStage uses? Or is it dependent on your server? our PX is installed on an AIX machine. How does one determine what codeset is used?
dsx, is that what you are looking for?
Brad.