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 WRITE to VSAM giving duplicate RC picus_mf CICS 1 Fri Feb 23, 2018 2:52 pm
No new posts Where to get sample for processing RM... vice_versa PL/I & Assembler 2 Tue Jan 16, 2018 2:03 pm
No new posts VSAM dataset not found abdulrafi JCL & VSAM 5 Fri Jan 12, 2018 11:19 am
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am

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