can ProfileStage/AuditStage analyze EBCDIC data?

datastage · Post by **datastage** » Fri Mar 12, 2004 11:00 am

I'm assuming PS and AS can't really analyze EBCDIC data. The AuditStage manual says 'If the data file contains non-ASCII data, such as EBCDIC, packed, or null characters,
the results may be unpredictable.'

This implies its not supported, but you could try, so has anyone tried something like this?

harrives · Post by **harrives** » Thu Sep 23, 2004 3:22 am

As far as I know the answer is no. I think that there is an iWay connector for ProfileStage for analysing EBCDIC.

Mike · Post by **Mike** » Thu Sep 23, 2004 6:22 am

In the case of AuditStage (last version I used was the former Quality Manager), it depends on the data source. There is no problem analyzing data in a mainframe DB2 database (probably because the DB2 Connect middleware handles the EBCDIC -> ASCII conversion). If you're talking mainframe flat files or VSAM files, then these would need to be converted to regular ASCII text files (and I think ftp'd and imported) before you can analyze them.

Mike

ray.wurlod · Post by **ray.wurlod** » Thu Sep 23, 2004 3:35 pm

The short answer is no but, if you're invoking from DataStage, then the conversion could be done "up front". Some FTP clients also have the ability to translate from EBCDIC to ASCII.