Hello,
I'm using a job reading a COBOL file PxCFF.
I read a column PIC 9(13)V9(4) COP-3.
Metadata for this columns are defined as follow 'Decimal (17,4)' in DataStage and in the DB.
When I read the COBOL file I retrieve only 0000000000000.0000 even if there is different data in the file!?
I've an other field Decimal (15,6) which works fine.
Any one as an Idea if there is a parameter to set or anything else?
Thanks for the help,
Tony
COBOL file decimal read as 0.0
Moderators: chulett, rschirm, roy
Does your copybook read
?
The COMP-3 is a type of BCD encoding where 2 digits are packed into each byte. What does your source file look like in this column - it should contain what looks like unreadable characters.
orPIC 9(13)V9(4) COP-3.
Code: Select all
PIC 9(13)V9(4) COMP-3.
The COMP-3 is a type of BCD encoding where 2 digits are packed into each byte. What does your source file look like in this column - it should contain what looks like unreadable characters.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If there are only numbers in your file, then the column was not exported as a COMP-3 field. You need to correct either the file or the COBOL definition.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If there are only numbers in your file, then the column was not exported as a COMP-3 field. You need to correct either the file or the COBOL definition.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Try removing the COMP-3 from your copybook definition; but if you are using a fixed-width file definition this will change your field lengths/positions.
"PIC 9(13)V9(4) COMP-3" uses 7 Bytes in the file,
"PIC 9(13)V9(4)." uses 13 Bytes in the file.
"PIC 9(13)V9(4) COMP-3" uses 7 Bytes in the file,
"PIC 9(13)V9(4)." uses 13 Bytes in the file.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Sorry, but that's not correct. The COMP-3 field will take 9 bytes in physical storage, and the DISPLAY field (default when no other qualifiers are in the PIC clause) will take 17 bytes.ArndW wrote:"PIC 9(13)V9(4) COMP-3" uses 7 Bytes in the file,
"PIC 9(13)V9(4)." uses 13 Bytes in the file.
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
FranklinE - you are absolutely correct, I looked at the 13 and neglected the 4 decimal places. Thanks for correcting that.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>