EBCDIC to ASCII converion mapping

dsx · Post by **dsx** » Mon Sep 19, 2005 3:50 pm

Any idea where to find the EBCDIC to ASCII conversion mapping used by DataStage ?

Appreciate your input.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 19, 2005 4:27 pm

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?

cmmurari · Post by **cmmurari** » Tue Sep 20, 2005 12:24 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Sep 20, 2005 1:09 am

As a general rule, BASIC functions aren't available efficiently in parallel jobs.

bcarlson · Post by **bcarlson** » Fri Sep 30, 2005 3:08 pm

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.