Error in Reading sequential file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Shruthi
Participant
Posts: 74
Joined: Sun Oct 05, 2008 10:59 pm
Location: Bangalore

Error in Reading sequential file

Post by Shruthi »

Hi, I'm reading decimal data using sequential file stage in fixed width format.
No signed bit is assigned. So, Packed= no (zoned) is selected.

For decimal(4), if data is 111a, then data is not rejected. Instead, its read as -1.

If data is 11a1 or 1a11, its getting rejected correctly.

When the last digit is not decimal, the record is not getting rejected and is getting read as -1. We want this record to be rejected. How can this be acheived?
Shruthi
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Is the source from COBOL structures?

Maybe it is declared as imperative signed - i.e. S.

Try 111b. Does it return -2 ? Normally it starts from p. i.e. 000p = -1.

From the look it appears to be using as Comp-9.
Shruthi
Participant
Posts: 74
Joined: Sun Oct 05, 2008 10:59 pm
Location: Bangalore

Post by Shruthi »

Thanks Sainath for your reply
Source is from COBOL structures. As said, it gives -1 for 111b. How should I proceed. We dont have access to premium content
Shruthi
Post Reply