Hi,
Could you please explain what is SPANINC, when i am loading the data from the file to db2 table using LOAD utility in JCL i am getting SPANINC=RC16 in the SYSOUT spool.
I hope with this, i am unable to load the data properly from file to table...
ie., part of the data loading into the table properly..
What will i do for not getting SPANINC=RC16.
Could any one please advise me on this ASAP.
Thanks in advance...
solve SPANINC=RC16
Moderators: Frank Yaeger, DikDude, Moderator Group
-
- Member
- Posts: 17
- Joined: Wed Sep 07, 2011 9:27 am
- Location: india
solve SPANINC=RC16
santhosh
Forums typically do not "do" ASAP.
To get help, you need to post the submitted jobstream and the diagnostic information generated. Do not pick and choose what you think is needed.
To get help, you need to post the submitted jobstream and the diagnostic information generated. Do not pick and choose what you think is needed.
Last edited by DikDude on Fri Sep 09, 2011 11:48 pm, edited 1 time in total.
Have a good one
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
SPANINC only applies to spanned input files, e.g. RECFM=VBS.
From the DFSORT Installation and Customization Guide:
SPANINC
specifies the action to be taken by DFSORT when one or more incomplete spanned records are detected in a variable spanned input data set.
RC0 specifies that DFSORT should issue message ICE197I (once), set a return code of 0, and eliminate all incomplete spanned records it detects. Valid records will be recovered.
RC4 specifies that DFSORT should issue message ICE197I (once), set a return code of 4, and eliminate all incomplete spanned records it detects. Valid records will be recovered.
RC16 specifies that DFSORT should issue message ICE204A, terminate, and give a return code of 16 when an incomplete spanned record is detected.
Default: RC16
Notes:
1. The return code of 0 or 4 set for incomplete spanned records can be overridden by a higher return code set for some other reason.
2. In cases where a spanned record cannot be properly assembled (for example, it has a segment length less than 4 bytes), DFSORT issues message ICE141A and terminates with a return code of 16. The SPANINC value has no effect in these cases.
If you want DFSORT to use SPANINC=RC0, you can add this to your step:
From the DFSORT Installation and Customization Guide:
SPANINC
specifies the action to be taken by DFSORT when one or more incomplete spanned records are detected in a variable spanned input data set.
RC0 specifies that DFSORT should issue message ICE197I (once), set a return code of 0, and eliminate all incomplete spanned records it detects. Valid records will be recovered.
RC4 specifies that DFSORT should issue message ICE197I (once), set a return code of 4, and eliminate all incomplete spanned records it detects. Valid records will be recovered.
RC16 specifies that DFSORT should issue message ICE204A, terminate, and give a return code of 16 when an incomplete spanned record is detected.
Default: RC16
Notes:
1. The return code of 0 or 4 set for incomplete spanned records can be overridden by a higher return code set for some other reason.
2. In cases where a spanned record cannot be properly assembled (for example, it has a segment length less than 4 bytes), DFSORT issues message ICE141A and terminates with a return code of 16. The SPANINC value has no effect in these cases.
If you want DFSORT to use SPANINC=RC0, you can add this to your step:
Code: Select all
//DFSPARM DD *
OPTION SPANINC=RC0
/*
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
-
- Member
- Posts: 17
- Joined: Wed Sep 07, 2011 9:27 am
- Location: india
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page