Check the existance of the data in VSAM in CICS program.

[Shuku]

Hi,

We have a VSAM file with merchant number details. On a CICS map, the user will enter a merchant number. The condition I want to check is that if the merchant number is exists in the VSAM only then the next map should be displayed on screen. What is proper way to check merchant number in the VSAM for this? Please suggest me on this.

[Robert Sample]

Your question, as posted, is so fuzzy as to not be answerable. 

We have a VSAM file with merchant number details.

Well, VSAM data sets (they are NEVER "files" -- files is a term on the mainframe used for Unix System Services which runs as part of z/OS) can be sequential (ESDS), indexed (KSDS), relative (RRDS), and linear.  Since you did not tell us which type of VSAM data set you are dealing with, that makes the question pretty much unanswerable as written.
If you have a VSAM KSDS (which is common), and the merchant number is the key then just use a CICS READ against the VSAM data set.  The response code will tell if you that record exists.  If the merchant number is not the key, then you'll have to build the key and read (possibly a number of records) to determine if the merchant number exists.
If the VSAM data set is not KSDS, then you'll need to work with your team lead / coworkers to determine how to tell if the merchant number exists.
There is no "proper" (I assume you meant standard) way to do this -- it all depends upon the application and how the VSAM data set is laid out.

[enrico-sorichetti]

 

What is proper way to check merchant number in the VSAM for this? Please suggest me on this

by using the appropriate handle condition for the record not found error  

Code: Select all

EXEC CICS HANDLE CONDITION
    ...
    NOTFND(X000-NOT-FOUND-PARA)
    ...
END-EXEC.

even better, ask Your colleagues, Your support about the standards in place for error handling

[Shuku]

Your question, as posted, is so fuzzy as to not be answerable. 

We have a VSAM file with merchant number details.

Well, VSAM data sets (they are NEVER "files" -- files is a term on the mainframe used for Unix System Services which runs as part of z/OS) can be sequential (ESDS), indexed (KSDS), relative (RRDS), and linear.  Since you did not tell us which type of VSAM data set you are dealing with, that makes the question pretty much unanswerable as written.
If you have a VSAM KSDS (which is common), and the merchant number is the key then just use a CICS READ against the VSAM data set.  The response code will tell if you that record exists.  If the merchant number is not the key, then you'll have to build the key and read (possibly a number of records) to determine if the merchant number exists.
If the VSAM data set is not KSDS, then you'll need to work with your team lead / coworkers to determine how to tell if the merchant number exists.
There is no "proper" (I assume you meant standard) way to do this -- it all depends upon the application and how the VSAM data set is laid out.

File is KSDS. And merchant number is the key for it.

[Robert Sample]

Do a direct key read of the VSAM data set using the key.  You can use HANDLE or the response code to determine how to proceed, based on whether or not the merchant key is found.

[Shuku]

Thanks fr the suggestion.