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
 

 

ICEMAN job to find number of records in a tape file

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

New User


Joined: 14 Sep 2006
Posts: 71
Location: Bangalore

PostPosted: Fri Dec 14, 2007 6:44 pm    Post subject: ICEMAN job to find number of records in a tape file
Reply with quote

Can you please post the ICEMAN job to find number of records in a tape file?

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

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 14, 2007 9:56 pm    Post subject:
Reply with quote

Hello,

If you do this with ICEMAN, or SORT, or any other utility that reads/counts the records, you will have to read all of the records.

If you talk with your storage management people, the info you want should be available in the tape management system and the data need not be processed to find the count.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Fri Dec 14, 2007 10:06 pm    Post subject: Reply to: ICEMAN job to find number of records in a tape fil
Reply with quote

roopannamdhari,


The following DFSORT JCL will give you the no of records in your tape dataset
Code:

//COUNT   EXEC  PGM=ICEMAN                           
//SYSOUT  DD SYSOUT=*                             
//SORTIN  DD DSN=INPUT TAPE DATASET,
//           DISP=SHR
//SORTOUT DD SYSOUT=*               
//SYSIN   DD *                     
  SORT FIELDS=COPY                   
  OUTFIL REMOVECC,NODETAIL,         
  TRAILER1=('NO: OF RECORDS: ',COUNT)
//*     


Hope this helps...
Back to top
View user's profile Send private message
roopannamdhari
Warnings : 1

New User


Joined: 14 Sep 2006
Posts: 71
Location: Bangalore

PostPosted: Sat Dec 15, 2007 10:23 am    Post subject:
Reply with quote

thanks a lot Skolusu...
Back to top
View user's profile Send private message
roopannamdhari
Warnings : 1

New User


Joined: 14 Sep 2006
Posts: 71
Location: Bangalore

PostPosted: Sat Dec 15, 2007 10:30 am    Post subject:
Reply with quote

Hi Kolusu,

can you please explain for what this REMOVECC & NODETAIL stands for ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Dec 15, 2007 10:41 am    Post subject:
Reply with quote

Hello,

REMOVECC removes ANSI control characters from the report.

NODETAIL prevents detail records from being written to OUTFIL.


If your tape file might have a few hundred million records, i'd still suggest getting the info you want without reading all of the records. . . .
Back to top
View user's profile Send private message
roopannamdhari
Warnings : 1

New User


Joined: 14 Sep 2006
Posts: 71
Location: Bangalore

PostPosted: Sat Dec 15, 2007 10:45 am    Post subject:
Reply with quote

Thank you ..
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Sun Dec 16, 2007 12:28 am    Post subject:
Reply with quote

Quote:
can you please explain for what this REMOVECC & NODETAIL stands for ?


For complete details on all of the parameters of DFSORT's OUTFIL statement, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.13?DT=20060615185603

You can access all of the DFSORT books online from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
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 find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
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


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