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
 
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: 4650
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 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 Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm
No new posts Matching and unmatched records!! Vignesh Sid SYNCSORT 3 Thu Nov 09, 2017 11:22 am

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