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
 

 

Access a VSAM file from CICS using the alternate key

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
ashwinjeerigi

New User


Joined: 20 Jun 2004
Posts: 12
Location: BANGALORE

PostPosted: Mon Jul 26, 2004 9:24 pm    Post subject: Access a VSAM file from CICS using the alternate key
Reply with quote

Hi all,

How do I access a VSAM file from CICS using the alternate key for that file.

We use RIDFLD to specify the primary key. How do I do it for Alternate key.

Pls reply soon

regards
Ashwin
Back to top
View user's profile Send private message

mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Wed Jul 28, 2004 12:52 am    Post subject:
Reply with quote

Hi Ashwin,

When creating a file w/an alt index a PATH must be created for each alt index.

In CICS you would use the name of this path in the FILE clause of the CICS I/O stmt, NOT the base file name. The RIDFLD should contain the value of the alt key you want to reference.

Regards, Jack.
Back to top
View user's profile Send private message
ashwinjeerigi

New User


Joined: 20 Jun 2004
Posts: 12
Location: BANGALORE

PostPosted: Wed Jul 28, 2004 9:54 pm    Post subject:
Reply with quote

Hi Jack,

Thanx for the reply. Do I register the Path name in FCT. If so then does it take the base KSDS name automatically. Pls reply.

regards
Ashwin
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Thu Jul 29, 2004 11:17 pm    Post subject:
Reply with quote

Hi Ashwin,

I'm not sure how (if) the FCT relates to the path name. I do know that a path is created via IDCAMS (it is NOT done automatically) as part of building the AIX.

You can check the cntl card library for the path name. It usually contains the 1st 7 chars of the DDNAME of the base file and uses the 8th position to make the name unique.

That's about all I can suggest. Maybe someone else has more specific info.

Another thought:

If you have access to the CICS proc, you can look for the DDNAMES associated w/the base cluster and the AIX. Use the DDNAME of the AIX for the I/O cmds referencing the AIX. If the file is used in batch, check out that JCL too.

Regards, Jack
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 6 Fri Jan 20, 2017 12:36 pm
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 1 Thu Jan 19, 2017 1:31 am
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
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


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