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
 

 

composite primary key of a vsam

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
mainakdalal

New User


Joined: 05 Sep 2005
Posts: 6
Location: kolkata

PostPosted: Tue Sep 13, 2005 3:05 pm    Post subject: composite primary key of a vsam
Reply with quote

Hi
I have a VSAM dataset with the primary key devided into two sub keys which are not contiguous. for example a file with the following feilds

ID name invoice_num date

has its primary key formed with ID and invoice_num. Now pls tell me how to define the VSAM.
Back to top
View user's profile Send private message

pa1chandak
Currently Banned

New User


Joined: 31 Jan 2006
Posts: 55

PostPosted: Fri Feb 03, 2006 3:31 pm    Post subject:
Reply with quote

WHILE CREating the vsam give key as the combination of both

like if record is like this

0110 2001

give key as (8,0)



pawan
Back to top
View user's profile Send private message
fixdoubts

New User


Joined: 21 Oct 2005
Posts: 54

PostPosted: Fri Feb 03, 2006 3:47 pm    Post subject:
Reply with quote

Hi,

i could not under stand what you want

If you have three fields like

ID-NAME-INVOICE

You cant have ID and INVOICE as keys

for the VSAM data sets you got to have your key fields contineous i,.e

ID-INVOICE-NAME

Then you can define Length of (ID+INVOICE) as key

Correct me if am wrong

Regards,
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Fri Feb 03, 2006 9:49 pm    Post subject:
Reply with quote

why don't u reformat the file using a sort or fileaid option to swap the positions of name and invoice_num so that u will get the ID and INVOICE fields continous to make the key.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm


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