In the cobol file definition provided one of the columns provided is PIC-9.9.
But the complex flat file stage was not able to import this column.
Can some one please let me know how this column can be imported.
I am getting the below error
'PIC' PICTURE character string format is invalid.
How to read PIC -9.9 in complex flat file
Moderators: chulett, rschirm, roy
How to read PIC -9.9 in complex flat file
Thanks
Sheema
Sheema
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: How to read PIC -9.9 in complex flat file
Declaring the data type as PIC +9.9 or PIC -9.9 is perfectly valid in Cobol world but DS is not able read it.Change the copy book to PIC X(4) for that field and try reading the source file.
Re: How to read PIC -9.9 in complex flat file
That's correct for Cobol, but I don't recommend changing the format type for the column. Adjust the numeric formatting first as Ray suggests, and change to Char only if it doesn't work.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
Re: How to read PIC -9.9 in complex flat file
Problem is not with the sign but '.' DataStage table definition import somehow is not able to read the real decimal. Changing it to S9(1).9(1) or S9.9 will not work