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?
can ProfileStage/AuditStage analyze EBCDIC data?
can ProfileStage/AuditStage analyze EBCDIC data?
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.
"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.
"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
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
Mike
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.