Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Number of records in a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
keane

New User


Joined: 24 Jul 2006
Posts: 11

PostPosted: Mon Apr 19, 2010 6:42 pm    Post subject: Number of records in a file
Reply with quote

I need to write number of input records (count) into an output file. After searching this forum i got the following code.

//SYSIN DD *
SORT FILEDS=COPY
OUTFIL REMOVECC,
TRAILER1=(COUNT=(M11,LENGTH=9))
/*

But This is writing all the input records into output file along with count as trailer record. I just want one record output (only count) in the output file.
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Mon Apr 19, 2010 6:51 pm    Post subject:
Reply with quote

NODETAIL = Specifies that data records are not to be output for the reports produced for this OUTFIL group.
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Mon Apr 19, 2010 6:51 pm    Post subject:
Reply with quote

Use NODETAIL in your control card.

Code:

  OPTION COPY                                       
  OUTFIL NODETAIL,REMOVECC,                         
     TRAILER1=('COUNT=',COUNT=(M11,LENGTH=09)) 


Thanks,
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Mon Apr 19, 2010 6:52 pm    Post subject: Reply to: Number of records in a file
Reply with quote

Already asked and answered by the same poster:

http://www.ibmmainframes.com/viewtopic.php?t=20518&highlight=
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Apr 19, 2010 7:34 pm    Post subject: Reply to: Number of records in a file
Reply with quote

Just for reference, it is also included in "DFSort Smart Tricks" paper now.
Back to top
View user's profile Send private message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 134
Location: India

PostPosted: Mon Apr 19, 2010 8:09 pm    Post subject:
Reply with quote

Hi Anuj,
Can you please give the path for "DFSort Smart Tricks" paper that you mentioned so that i can read this?
Thanks
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Mon Apr 19, 2010 8:10 pm    Post subject:
Reply with quote

start here: http://ibmmainframes.com/viewtopic.php?t=1348

or more specifically:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Mon Apr 19, 2010 8:11 pm    Post subject:
Reply with quote

Here it is...

ftp://ftp.software.ibm.com/storage/dfsort/mvs/sorttrck.pdf

Thanks,
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Mon Apr 19, 2010 8:12 pm    Post subject:
Reply with quote

Nevermind,..

Dick Brenholtz's link is far more useful....

Thanks,
Back to top
View user's profile Send private message
keane

New User


Joined: 24 Jul 2006
Posts: 11

PostPosted: Mon Apr 19, 2010 9:07 pm    Post subject: Reply to: Number of records in a file
Reply with quote

All of you,

Thanks alot. It is working fine.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us