GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Mainframe  >  JCL
Go To First  |  Previous Question  |  Next Question 
 JCL  |  Question 49 of 126    Print  
How can I get the number of records of a sequential file without browsing it?

  
Total Answers and Comments: 6 Last Update: May 21, 2007     Asked by: Basu 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 18, 2006 05:58:46   #1  
venkey        

RE: How can I get the number of records of a sequentia...

hi,

u can use tso command "COUNT" over sequential dataset to know the number of records in it with out browsing it.


 
Is this answer useful? Yes | No
August 20, 2006 08:41:27   #2  
Sumit        

RE: How can I get the number of records of a sequential file without browsing it?
No. of records present in file can be count with help of sort job. In SORTIN give your input file name and give SORTOUT as dummy in sysin paramtere give the control card "sort fields=copy". and submit the job you will find out the number of records in sysout of job.
 
Is this answer useful? Yes | No
August 25, 2006 15:26:34   #3  
srilkrishy Member Since: May 2006   Contribution: 5    

RE: How can I get the number of records of a sequentia...

Hi,

Here are the diffrent methods to get the count of records.

1)you can use the SORT tool count option.

2)you can generate a sequence number on each record and then select the last record thru SELECT option of the sort and OUTREC only the sequence number columns.

3)Add a 000001 character thru INREC option of the SORT and add them up to get the count.

The below 2 can used just to check the number of records.

1)Use the REPRO command of IDCAMS

2)use the file aid 3.5 option and see the number of records.

 

Thank you

Krishy


 
Is this answer useful? Yes | No
November 12, 2006 23:44:30   #4  
Michael Kaplan        

RE: How can I get the number of records of a sequentia...
 You can use count parameter in Icetool
 
Is this answer useful? Yes | No
January 10, 2007 05:26:18   #5  
P.Karthikkumar        

RE: How can I get the number of records of a sequentia...

//JOBNAME...

//STEP1     EXEC    PGM=FILEAID

//SYSOUT       DD  SYSOUT=*

//SYSPRINT    DD   SYSOUT=*

//DD1      DD    DSN=A.B.C,DISP=SHR

//SYSIN   DD *

 $$DD1  TALLY

/*

//


 
Is this answer useful? Yes | No
May 21, 2007 21:13:27   #6  
kckinney Member Since: May 2007   Contribution: 48    

RE: How can I get the number of records of a sequentia...
Sort it, dummying out SORTOUT
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape