IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Count the Number of records present in a File


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
raajan_p

New User


Joined: 19 Sep 2005
Posts: 17

PostPosted: Wed Nov 09, 2005 9:35 am
Reply with quote

Hi All,

I want to count the number of records present in a file.

I dont have DFSORT utility in my shop and so i am unable to use ICETOOL.

Is it possible to count the number of records present in a file using SORT or SYNCSORT. If so please let me know.

Thanks,
Raajan.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Wed Nov 09, 2005 10:31 am
Reply with quote

Raajan,

Make a search before posting ....

http://ibmmainframes.com/viewtopic.php?t=1832

Regards,

Priyesh.
Back to top
View user's profile Send private message
sathish_rathinam

New User


Joined: 22 Aug 2005
Posts: 59
Location: india

PostPosted: Wed Nov 09, 2005 7:04 pm
Reply with quote

hi rajan,

u can get the no of records in a file using fileaid option 3.8 (batch interactive facility) ,just give the input file name and press enter..
In the next screen type 'TALLY' ,u will get the no of records easily ,instead of using DFSORT or ICETOOL ..this can be a more easier one


cheers,
sathish
Back to top
View user's profile Send private message
simham

New User


Joined: 29 Sep 2005
Posts: 12

PostPosted: Thu Nov 10, 2005 10:17 am
Reply with quote

hi sathish,

can you please let us know the possible functions (like tally) we can use under 3.8 in file-aid.

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

New User


Joined: 22 Aug 2005
Posts: 59
Location: india

PostPosted: Thu Nov 10, 2005 10:27 am
Reply with quote

hi simham,

The other functions we make use IN FILEAID 3.8 r COPY,DROP,DUMP,COMPARE,CONVERT,REFORMAT,PRINT,UPDATE..

cheers,
sathish
Back to top
View user's profile Send private message
raajan_p

New User


Joined: 19 Sep 2005
Posts: 17

PostPosted: Thu Nov 10, 2005 8:40 pm
Reply with quote

Hi Guys,

Thanks a lot for your replies.

Regards,
Raajan
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts To get the count of rows for every 1 ... DB2 3
Search our Forums:

Back to Top