Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 6 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us