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
 

 

Extracting the last record from a sequential file

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

New User


Joined: 23 Jan 2007
Posts: 12
Location: India

PostPosted: Wed Jan 30, 2008 3:22 pm    Post subject: Extracting the last record from a sequential file
Reply with quote

Hi All,

I need to extract the last record from a sequential file which contains some million records. I tried doing it using ICETOOL by skipping (count-1) records and it is working. I also tried TRAILER1 in DFSORT and it gave me the desired output.

But these methods scan all the million records to get the count of number of records and then extract the last record. What I want is a method by which we can extract the last record without scanning through the entire file? Please note that this is a Physical Sequential file.

Any ideas are welcome. Please get back to me in case of any queries.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jan 30, 2008 4:37 pm    Post subject:
Reply with quote

Unless you read the file, how else will you know when you have reached the last record ?
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Wed Jan 30, 2008 4:43 pm    Post subject: Reply to: Extracting the last record from a sequential file
Reply with quote

Hi Sharath,

You can use Fileaid to read the file backwards. While copying, select option 1 (selection criteria). Here you can mention that you want to do backward processing. Also you can mention how many records you want to select(in your case 1) and you many records need to be searched.

Hope it clears.

-Ajay
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


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