IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Access a VSAM file from CICS using the alternate key


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 7
No new posts Using API Gateway from CICS program CICS 0
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top