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 Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm


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