Page 1 of 1

Packed Decimal Data Type

Posted: Wed Dec 21, 2005 2:32 am
by reddyds
Hi

I have a packed Decimal Data (19,4) iam not able to read the file using Complex Flat File as well as sequential file does PX have any particular stage to read a *.dat file with Packed Decimal Data.

Srikanth Reddy

Posted: Wed Dec 21, 2005 2:46 am
by ArndW
reddyds,

DataStage supports packed decimal fields. The CFF can do this and a normal sequential stage and use of the sdk functions accomplishes this as well. You will need to explain what your problem is before someone can assist you. Were the packed fields written by PL1 or Cobol? What have you done and what was the error are some of the basic questions whose responses you should post. Easiest would be if you could narrow down the problem to just your packed decimal column to make sure your columns aren't mixed up.

Packed Decimal Datatype

Posted: Wed Dec 21, 2005 6:03 am
by reddyds
Hi ArndW

Thanx for the response iam trying to read a cobol written Packed Decimal type data filelds with (19,4) as length as there is no specifc data type as Packed Decimal in CFF Stage and when i try to read it as decimal one it is not taking more than (18,4) as length so how to go abt it.

Regards
Srireddy