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
 

 

No. of Records in Dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
chkiran2

New User


Joined: 24 Jun 2004
Posts: 24
Location: Gurgoan

PostPosted: Fri Jul 09, 2004 2:30 pm    Post subject: No. of Records in Dataset
Reply with quote

Hi
Using JCL how can we find the total number of records in a dataset. Are there any tools specific for this or can we use SORT/SYNCSORT to do this. If so how to do that? Can some one help me giving code to do that.

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

sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 151
Location: Tokyo, Japan

PostPosted: Fri Jul 09, 2004 3:15 pm    Post subject:
Reply with quote

Hi Kiran,
If you copy the dataset to any temporary file using IDCAMS or SORT the at the spool you will get the output records copied or OUT count (in case of sort).
Code:
//STEP01  EXEC PGM=SORT
//SORTIN   DD  DSN=INPUT DSN,DISP=SHR
//SORTOUT  DD  DSN=&&TEMP,DISP=Give as your input
//SORTLIB  DD  DSN=SYS1.SORTLIB,
//            DISP=SHR
//SORTWK01 DD  UNIT=DISK,SPACE=(CYL,50,,CONTIG)
//SORTWK02 DD  UNIT=DISK,SPACE=(CYL,50,,CONTIG)
//SYSOUT   DD  SYSOUT=*
//SYSIN    DD  *
    SORT   FIELDS=COPY
/*
//*

Or IDCAMS
Code:
//SAVE    EXEC PGM=IDCAMS
//SYSPRINT  DD SYSOUT=*
//IN        DD DSNINPUT DSN,
//            DISP=SHR
//OUT       DD DSN=&&TEMP,other as your input
//SYSIN     DD *
   REPRO INFILE(IN) OUTFILE(OUT)
//*
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 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 To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts LISTCAT on a dataset with symbolic pa... shreya19 JCL & VSAM 5 Fri Apr 07, 2017 5:43 pm
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm


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