Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Not able to export the VSAM cluster sandeep kumar302 JCL & VSAM 5 Fri May 04, 2018 12:42 pm
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 Tue Apr 17, 2018 10:42 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm
No new posts VSAM File free space sancraig16 JCL & VSAM 13 Fri Mar 30, 2018 1:02 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us