Problem with reading packed deciaml data with MQ Stage.

[dhwankim]

Hi Guru.

We try to get data through MQ Stage from Mainfram data.
but Problem is at packed decimal data.

For example 3 cols exist in Queue. A, B, C
A col type is char, B col type is packed decimal and C col type is Char.

Problem is in Col B. If B contain '2000'
Hex values is 02000C. but When I write data into Sam file with DataTypePicComp routine. written value is '20' Only...

When I draw job , I made col b type to char with NLS None(Ascentail recommanded).

Any one has some exprience like that, workgorup or Tips.

For additional information, I installed datastage 7 on AIX 5.1 Now.


Please Let me know it.