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
 

 

Retrieval of records in KSDS

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

New User


Joined: 07 Aug 2007
Posts: 22
Location: Chennai

PostPosted: Tue Sep 25, 2007 5:25 pm    Post subject: Retrieval of records in KSDS
Reply with quote

1). I have a KSDS file containing millions of records which is accessed sequentially. I don't know the address or the position of the record in the file. I want to access the file from the last record. Please let me know the possibilities and the methods of doing this.

2). Could anyone let me know as why PATH is being used? As we know, PATH establishes a relationship between the base cluster and the AIX cluster. But still without PATH itself we can access the AIX cluster, am I right? If so, why we go for PATH? Is it mandatory to be defined?
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Sep 25, 2007 5:31 pm    Post subject:
Reply with quote

Try a search on last record ksds......
Back to top
View user's profile Send private message
Priya_Shankar

New User


Joined: 07 Aug 2007
Posts: 22
Location: Chennai

PostPosted: Tue Sep 25, 2007 5:39 pm    Post subject: Reply to: Retrieval of records in KSDS
Reply with quote

I am not able to get you, could you please elaborate on this? Thanks!
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4649
Location: Raleigh, NC, USA

PostPosted: Tue Sep 25, 2007 5:44 pm    Post subject: Reply to: Retrieval of records in KSDS
Reply with quote

As is suggested in the link, you can either sort the file, adding a record counter value, sorting on the record count in descending order, and selecting the first entry (i.e. the last record). Or, by using File-Aid as shown.
Back to top
View user's profile Send private message
Priya_Shankar

New User


Joined: 07 Aug 2007
Posts: 22
Location: Chennai

PostPosted: Tue Sep 25, 2007 5:48 pm    Post subject: Reply to: Retrieval of records in KSDS
Reply with quote

Thanks and Sorry, I didn't view that the reply given was a link.
Back to top
View user's profile Send private message
Priya_Shankar

New User


Joined: 07 Aug 2007
Posts: 22
Location: Chennai

PostPosted: Thu Sep 27, 2007 11:01 am    Post subject: Reply to: Retrieval of records in KSDS
Reply with quote

Please let me know as why Path is being used.
Back to top
View user's profile Send private message
silentarya

New User


Joined: 11 Mar 2007
Posts: 35
Location: Chennai

PostPosted: Thu Sep 27, 2007 4:45 pm    Post subject: Reply to: Retrieval of records in KSDS
Reply with quote

If u use software like 1 fil or File Aid ... It will be quite easy ... However, u can sort the file in JCL ... Then read it from the end ... In case if u find any problem, u can also use repro to transfer the data to a flat file ... sort it there ... Do the changes and use repro back to get your KSDS ...
Back to top
View user's profile Send private message
star_dhruv2000

New User


Joined: 03 Nov 2006
Posts: 87
Location: Plymouth, MN USA

PostPosted: Mon Nov 12, 2007 10:45 am    Post subject:
Reply with quote

Path is logical connection between AIX and Base Cluster.



AIX contains primary key pointer of base cluster and corresponding AIX keys as data. Thus if u use only AIX then in turn you will get just AIX keys and primary keys of corresponding data. Therefore to obtain records from base cluster as well you need to use PATH.

Its path which is been used in JCL and not AIX. Suppose your cluster is named
Code:
//MASTER DD DSN=BASE.CLUSTER.NAME,DISP=SHR


Then Path file is used as
Code:
//MASTER1 DD DSN=PATH.FILE.NAME,DISP=SHR


Hope I am clear with my thoughts..

Cheers
Happy Coding
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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


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