Reading Packed Data from Db2 table

Inquisitive · Post by **Inquisitive** » Fri Oct 06, 2006 12:55 am

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?

Any pointer to achieve this would be helpful.

Thanks

kumar_s · Post by **kumar_s** » Fri Oct 06, 2006 1:01 am

Why not to use DB2 API and Decimal datatype.

Inquisitive · Post by **Inquisitive** » Fri Oct 06, 2006 1:15 am

Will API stage automatically unpack the packed decimals stored in CHAR field?

At this point I am restricted to use ODBC, is there any way it could be done in ODBC stage?

ArndW · Post by **ArndW** » Fri Oct 06, 2006 1:20 am

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.

kumar_s · Post by **kumar_s** » Fri Oct 06, 2006 1:23 am

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.