Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
How to create VSAM file with multiple keys

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SMS & VSAM
Author Message
subinraj

New User


Joined: 04 Sep 2007
Posts: 7
Location: Trivandrum

PostPosted: Thu Mar 27, 2008 7:52 pm    Post subject: How to create VSAM file with multiple keys
Reply with quote

Hi,

I have a file with the following layout.
01 File.
05 WS-A PIC X(05).
05 FILLER PIC X(25).
05 WS-B PIC X(10).

Is it possible to define a VSAM KSDS cluster using WS-A and WS-B as the keys. If yes please give me the syntax.

Thanks in advance,
Back to top
View user's profile Send private message
References
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 3183
Location: italy

PostPosted: Thu Mar 27, 2008 7:56 pm    Post subject: Reply to: How to create VSAM file with multiple keys
Reply with quote

No!

for a vsam KSDS or AIX the key must be a contiguous number of chars

read the manual
( link at top of the page, scroll down, the manual is VSAM services )
Back to top
View user's profile Send private message
subinraj

New User


Joined: 04 Sep 2007
Posts: 7
Location: Trivandrum

PostPosted: Thu Mar 27, 2008 8:14 pm    Post subject: Thanks for the reply
Reply with quote

Thanks for the quick response
Back to top
View user's profile Send private message
dick scherrer

Global Moderator


Joined: 23 Nov 2006
Posts: 8761
Location: 221 B Baker St

PostPosted: Thu Mar 27, 2008 9:48 pm    Post subject:
Reply with quote

Hello,

Do you want one key of both field a and field b or do you want a primary key of field a and an alternate key of field b?

As Enrico said, you cannot do the first.

If you wanted 2 keys with one field each, you could do that. . .
Back to top
View user's profile Send private message
subinraj

New User


Joined: 04 Sep 2007
Posts: 7
Location: Trivandrum

PostPosted: Fri Mar 28, 2008 9:28 am    Post subject:
Reply with quote

hello,

I wanted was the primary key using both WS-A and WS-B which is not possible as you said.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SMS & VSAM All times are GMT + 6 Hours
Page 1 of 1