Reading issue for a cobol file.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Reading issue for a cobol file.
Hi All,
I am getting the below error for cobol file
At field "MI_NBR_OF_TABLE_ENTRIES": In link field conversion: Possible range limitation
It is a cobol file with occurs depending on clause..
and I have the following options on..
record delimiter as blank
Record type variable block..
And I tried changing the record delimiter to DOS format and then it gives me the following error
Cannot recognize the supplied schema.
>##E IIS-DSEE-TFRS-00057 11:29:40(019) <XX_YYY> "record_delim" must be a single-char string or "null" (use "record_delim_string" for multi-char delimiter), text: {record_delim="DOS format", delim=none, quote=none, binary, ebcdic, native_endian, charset=ASCL_EBCDIC, round=round_inf, nofix_zero}
Looks like a record limiter issue to me as it (the same file) was successfully read in Abinitio by a different group ..with \r\n
And I read the datastage manual , that it handles occurs depending on clause.
Any thoughts greatly appreciated.
Thank you all.
I am getting the below error for cobol file
At field "MI_NBR_OF_TABLE_ENTRIES": In link field conversion: Possible range limitation
It is a cobol file with occurs depending on clause..
and I have the following options on..
record delimiter as blank
Record type variable block..
And I tried changing the record delimiter to DOS format and then it gives me the following error
Cannot recognize the supplied schema.
>##E IIS-DSEE-TFRS-00057 11:29:40(019) <XX_YYY> "record_delim" must be a single-char string or "null" (use "record_delim_string" for multi-char delimiter), text: {record_delim="DOS format", delim=none, quote=none, binary, ebcdic, native_endian, charset=ASCL_EBCDIC, round=round_inf, nofix_zero}
Looks like a record limiter issue to me as it (the same file) was successfully read in Abinitio by a different group ..with \r\n
And I read the datastage manual , that it handles occurs depending on clause.
Any thoughts greatly appreciated.
Thank you all.
Generally COBOL files have no delimiters.
What is the PICture for MI_NBR_OF_TABLE_ENTRIES and what datatypes are you defining in DataStage for that column? Which stage is generating that runtime warning message?
What is the PICture for MI_NBR_OF_TABLE_ENTRIES and what datatypes are you defining in DataStage for that column? Which stage is generating that runtime warning message?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Below is the section from cobol where it is failing to read.
001970 02 MI-NBR-OF-TABLE-ENTRIES PIC S9(3) COMP.
019800 02 MI-PRODUCT-TABLE.
019900 05 MI-PROD-TBL OCCURS 0 TO 100 TIMES
020000 DEPENDING ON MI-NBR-OF-TABLE-ENTRIES
020100 INDEXED BY MI-IDX.
020200 10 MI-PRODUCT-CODE PIC S9(3) COMP-3.
020300 10 MI-PRODUCT-MONEY PIC S9(11)V99 COMP-3.
MI-NBR-OF-TABLE-ENTRIES in datastage is defined as smallint 3.
MI-PRODUCT-CODE --------in datastage is defined as Decimal(3)
MI-PRODUCT-MONEY in dastage stage is defined as Decimal(13,2).
Any inputs will be greatly appreciated.
Thank you all.
001970 02 MI-NBR-OF-TABLE-ENTRIES PIC S9(3) COMP.
019800 02 MI-PRODUCT-TABLE.
019900 05 MI-PROD-TBL OCCURS 0 TO 100 TIMES
020000 DEPENDING ON MI-NBR-OF-TABLE-ENTRIES
020100 INDEXED BY MI-IDX.
020200 10 MI-PRODUCT-CODE PIC S9(3) COMP-3.
020300 10 MI-PRODUCT-MONEY PIC S9(11)V99 COMP-3.
MI-NBR-OF-TABLE-ENTRIES in datastage is defined as smallint 3.
MI-PRODUCT-CODE --------in datastage is defined as Decimal(3)
MI-PRODUCT-MONEY in dastage stage is defined as Decimal(13,2).
Any inputs will be greatly appreciated.
Thank you all.
What happens when you remove all record delimiters in the CFF stage, that should either work or give a different error message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
I'm not at a location where I can check now, but I would suggest using a normal INTEGER instead of smallint for MI_NBR_OF_TABLE_ENTRIES.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Thanks for your quick reply.
On stage page and records tab , It was showing as Binary actually when imported and shows as small int the outputs page and column tab..
As you asked me to modify , I changed on the stage page to Numeric (as I didn't see any integer type available on the pull down) with the same length as 3 and in outputs page on columns tab now , it showed as decimal 3 still this didn't work.
any inputs greatly appreciated.
Thank you .
On stage page and records tab , It was showing as Binary actually when imported and shows as small int the outputs page and column tab..
As you asked me to modify , I changed on the stage page to Numeric (as I didn't see any integer type available on the pull down) with the same length as 3 and in outputs page on columns tab now , it showed as decimal 3 still this didn't work.
any inputs greatly appreciated.
Thank you .
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Kollurianu,
I understand that it is a COBOL file that you are dealing with. Also, my questions pertain to COBOL files only. I haven't personally dealt with ODO clauses, but there is an example given in the manual...thus my question "have you followed everything/every step from the manual".
I am also curious as to why you chose a "Variable Block" in the CFF.
I understand that it is a COBOL file that you are dealing with. Also, my questions pertain to COBOL files only. I haven't personally dealt with ODO clauses, but there is an example given in the manual...thus my question "have you followed everything/every step from the manual".
I am also curious as to why you chose a "Variable Block" in the CFF.
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm