How to Access Alternate Index ???



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

How to Access Alternate Index ???

Postby gauthamnagpur18 » Sat Oct 23, 2010 1:35 pm

Usually We access the KSDS through following command

Print ids(/) char

Similarly which command is used to access Alternate Index ???

Thanks in Advance .
gauthamnagpur18
 
Posts: 93
Joined: Sat Oct 23, 2010 1:28 pm
Location: Chennai, India
Has thanked: 3 times
Been thanked: 3 times

Re: How to Access Alternate Index ???

Postby NicC » Sat Oct 23, 2010 3:39 pm

What utility are you using to view the dataset? In an application program one usually accesses vsam files by providing a key.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to Access Alternate Index ???

Postby enrico-sorichetti » Sat Oct 23, 2010 5:13 pm

see this topic ( in a different forum - albeit )
http://ibmmainframes.com/about29269.html

which shows how ...
define a base clusted
define an aix / bldindx
define a path

the output shown are
the sysout of the defines/bldindx

the sysout of
(1) print the base cluster
(2)print the aix
(3)print the path

the fact that the base cluster in this case is an ESDS is IRRELEVANT
the overall logic is exactly the same

the (1) is evident
the (2) is irrelevant from an application point of view, but it shows the structure of the aix
the (3) will print the records in the order defined by the alternate index

read, enjoy, meditate :D
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times

Re: How to Access Alternate Index ???

Postby gauthamnagpur18 » Tue Oct 26, 2010 7:52 am

I have used IDCAMS Only . ....When KSDS is created , We cant access it directly .We can either repro to another flat file or we can use print ids(/) char in front of KSDS ...

Similarly , Whether there is any method to access Alternate Index .

Thanks enrico-sorichetti .
gauthamnagpur18
 
Posts: 93
Joined: Sat Oct 23, 2010 1:28 pm
Location: Chennai, India
Has thanked: 3 times
Been thanked: 3 times

Re: How to Access Alternate Index ???

Postby dick scherrer » Tue Oct 26, 2010 8:00 am

Hello,

When KSDS is created , We cant access it directly .
Why not? The main reason to have a ksds is so that it may be accessed directly. . .

Possibly there is something i misunderstand. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to Access Alternate Index ???

Postby Robert Sample » Tue Oct 26, 2010 3:50 pm

Did you try the print ids(/) on the PATH name?
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post