How to read PIC -9.9 in complex flat file

sheema · Post by **sheema** » Wed Nov 13, 2013 10:42 pm

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.

chulett · Post by **chulett** » Wed Nov 13, 2013 10:46 pm

Hmmm... I'd try changing the FD to show PIC S9.9 for that column and see if that works.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 14, 2013 1:42 am

"-" is not correct for showing a signed number. "S" is.

shiva459 · Post by **shiva459** » Thu Nov 14, 2013 11:03 am

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.

FranklinE · Post by **FranklinE** » Fri Nov 15, 2013 1:45 pm

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.

shiva459 · Post by **shiva459** » Sat Nov 16, 2013 5:37 am

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

DSXchange

How to read PIC -9.9 in complex flat file

How to read PIC -9.9 in complex flat file

Re: How to read PIC -9.9 in complex flat file

Re: How to read PIC -9.9 in complex flat file

Re: How to read PIC -9.9 in complex flat file