solve SPANINC=RC16

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
santhosh kumar
Member
Posts: 17
Joined: Wed Sep 07, 2011 9:27 am
Location: india

solve SPANINC=RC16

Post by santhosh kumar » Fri Sep 09, 2011 2:28 pm

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...
santhosh

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Fri Sep 09, 2011 9:03 pm

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.
Last edited by DikDude on Fri Sep 09, 2011 11:48 pm, edited 1 time in total.
Have a good one

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Fri Sep 09, 2011 10:03 pm

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:

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

santhosh kumar
Member
Posts: 17
Joined: Wed Sep 07, 2011 9:27 am
Location: india

Post by santhosh kumar » Mon Sep 12, 2011 1:52 pm

Hi Frank Yaeger,

Thanks for the reply,

I have a doubt, What is the RECFM for the file, when we load the data from file to db2 table using LOAD utility.

Could you please give me the reply, i will look for your reply,,

thanks!
santhosh

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Mon Sep 12, 2011 10:48 pm

As Frank already posted:
SPANINC only applies to spanned input files, e.g. RECFM=VBS.
This may be an internal use file, not a file you specified containing the data to load. . .
Have a good one

Post Reply

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



Other References
Mainframe Tools and others