View previous topic :: View next topic
|
Author |
Message |
Priya_Shankar
New User
Joined: 07 Aug 2007 Posts: 22 Location: Chennai
|
|
|
|
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 |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
Back to top |
|
|
Priya_Shankar
New User
Joined: 07 Aug 2007 Posts: 22 Location: Chennai
|
|
|
|
I am not able to get you, could you please elaborate on this? Thanks! |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
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 |
|
|
Priya_Shankar
New User
Joined: 07 Aug 2007 Posts: 22 Location: Chennai
|
|
|
|
Thanks and Sorry, I didn't view that the reply given was a link. |
|
Back to top |
|
|
Priya_Shankar
New User
Joined: 07 Aug 2007 Posts: 22 Location: Chennai
|
|
|
|
Please let me know as why Path is being used. |
|
Back to top |
|
|
silentarya
New User
Joined: 11 Mar 2007 Posts: 35 Location: Chennai
|
|
|
|
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 |
|
|
star_dhruv2000
New User
Joined: 03 Nov 2006 Posts: 87 Location: Plymouth, MN USA
|
|
|
|
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 |
|
|
|