I am trying to read DB2 table (Db2 on mainframe) which has Packed decimal data stored in CHAR field. I am using ODBC stage to read data.
When I import table definitions, te field is defined as CHAR and 'view data' shows some un-readable data in the field.
Now, how can I read that packed data from DB2 table?
You can use the SDK routines to unpack these fields. I'm not at a DataStage computer right now to tell you the exact name of the routine, but if you look under the SDK category you will find them.
You can use the datatype conversion avaialble in Transformer (sdk function available in DS Transform). Find the exact type in mainframe and use the appropriate function.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'