Page 1 of 1
can ProfileStage/AuditStage analyze EBCDIC data?
Posted: Fri Mar 12, 2004 11:00 am
by datastage
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?
Posted: Thu Sep 23, 2004 3:22 am
by harrives
As far as I know the answer is no. I think that there is an iWay connector for ProfileStage for analysing EBCDIC.
Posted: Thu Sep 23, 2004 6:22 am
by Mike
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
Posted: Thu Sep 23, 2004 3:35 pm
by ray.wurlod
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.