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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am


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