View previous topic :: View next topic
|
Author |
Message |
raj4neo Warnings : 1 New User
Joined: 12 May 2006 Posts: 51 Location: India
|
|
|
|
Hi ,
Whether a Sort card can give ,
To find the record count the Infile and write the count to Output file , if the count is less than 50
Say if Infile is having 100 Records , output file should be empty and If Infile is having 48 Output file should be like No of records Processed is 48
Thanks |
|
Back to top |
|
|
TheMFKid
New User
Joined: 20 Nov 2013 Posts: 91 Location: India
|
|
|
|
Code: |
SORT FIELDS=COPY
OUTFIL FILES=OUT,TRAILER1=(1:COUNT),REMOVECC,NODETAIL
|
This will help you count the number of records in your infile. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Add a sequence number, in the appropriate place, to your records.
INCLUDE= on OUTFIL for that sequence less than/equal 50.. Format your output with BUILD. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Of course you could easily enough use an IDCAMS PRINT with count option and conditionally execute one of two subsequent steps to either copy the dataset with input or to create an empty output. |
|
Back to top |
|
|
|