Cobol - Problem with Packed fileds

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem with Packed fileds

Jyothy

2006-05-23, 9:55 pm

Hi All,

This is Jyothy.I am working on Migration Project.source is Main Frame
and Target is Teradata.I am extracting data through Power Exchange.In
My copybook , The field is defined as DATE PIC S9(7) COMP-3. when
Importing to Power Exchange I am getting the field data type as DATE
PACKED(7,0).When doing the row test I am getting the data as '61011'.
It is displaying as DATE DECIMAL(7,0) in INFORMATICA.Because of decimal
,leading zeros are getting truncated.Becomming invalidate for
DATE.Could you pls provide solution to unpack the data in the Power
Excahnge Itself? Or we have to do padding in the INFA?

Thanks
Jyothy

Sponsored Links