|
|
| Author |
Message |
mohitsaini
New User
Joined: 15 May 2006
Posts: 40
|
|
|
|
| Code: |
//SORTSTP EXEC PGM=SYNCSORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=B5586.M5586MPR.C558669G.G0699V00,DISP=SHR
// DD DSN=B5586.M5586MPR.C558669G.G0700V00,DISP=SHR
//SORTWK02 DD SPACE=(CYL,(100,50),RLSE)
//SORTWK03 DD SPACE=(CYL,(100,50),RLSE)
//SORTWK04 DD SPACE=(CYL,(100,50),RLSE)
//SORTWK05 DD SPACE=(CYL,(100,50),RLSE)
//SORTWK06 DD SPACE=(CYL,(100,50),RLSE)
//SORTWK07 DD SPACE=(CYL,(100,50),RLSE)
//SORTWK08 DD SPACE=(CYL,(100,50),RLSE)
//SORTOUT DD DSN=SS5355.MOHIT.DATA.COND,
// DISP=(,CATLG,DELETE),
// DCB=(RECFM=FB,LRECL=32500,BLKSIZE=0),
// SPACE=(CYL,(100,50),RLSE),VOL=(,,,100)
//SYSIN DD *
INCLUDE COND=(18322,1,CH,EQ,C'Y')
SORT FIELDS=(5197,7,PD,A,5,8,BI,D)
/*
//
|
This is the step that I am using to filter out some records. The record length of the input file is = 32500. This step is generating no records whatsoever in the output file. I am sure that the records are present in the input file with the criteria mentioned in my INCLUDE COND. It looks like sorting fails --> INCLUDE COND=(18322,1,CH,EQ,C'Y') fails when we start giving high starting position as in this case it is 18322. Is it true? |
|
| Back to top |
|
 |
References
|
 Posted: Thu Jun 26, 2008 11:17 am Post subject: Re: Include condition is failing in produce any output |
|
|
|
|
| Moved: Thu Jun 26, 2008 11:19 am by superk From DFSORT/ICETOOL to JCL |
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 7470
Location: 221 B Baker St
|
|
|
|
Hello,
Is the file variable length by chance?
If it is, did you add 4 for the RDW? |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 445
|
|
|
|
Hi,
are you saying the sort fails or no records are found.
Try copying 1 record out to disk, edit the file online and see what is in position 18322. Run the job against this file specifying the character in position 18322 and see if it works.
I tried it using DFSORT without any problems, ie. it extracted the record.
I'm assuming your input file is FB.
Gerry |
|
| Back to top |
|
|
mohitsaini
New User
Joined: 15 May 2006
Posts: 40
|
|
|
|
Dick, it is is of Fixed length.
Gcichet, it is no records found. Sort is not failing.
From your replies it looks like there is some fault from my end only. High number as a starting position works.
Currently I am looking into the input files. Will give you an update as soon as I get a breakthrough.
Thanks for your time. |
|
| Back to top |
|
|
|
|
|
