Can STP use VSAM?
-
- New Member
- Posts: 2
- Joined: Fri May 06, 2016 11:04 am
Can STP use VSAM?
Hi,
Can STP use VSAM datasets? I have searched about it but in vain. Can some one suggest about it?
Can STP use VSAM datasets? I have searched about it but in vain. Can some one suggest about it?
- Robert Sample
- Global Moderator
- Posts: 1895
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Can STP use VSAM?
Assuming you mean Server Time Protocol when you say "STP", then the answer is no. STP uses coupling facility links, which are not VSAM. If you meant something other than Server Time Protocol when you said "STP", you will need to explain what you meant.
- Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Can STP use VSAM?
I'll hazard a guess STP is used for "Stored Procedure", in this context. But as the topic is in Other Mainframe Topics, Off-Topics, FAQs. part of the Forum, I may be way off mark guessing!
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
- Robert Sample
- Global Moderator
- Posts: 1895
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Can STP use VSAM?
STP in the US is usually an additive for automobile fuel and has nothing to do with mainframes.
-
- New Member
- Posts: 2
- Joined: Fri May 06, 2016 11:04 am
Re: Can STP use VSAM?
I was asking about DB2 Stored Procedures. Can you please explain if VSAM can be used in a DB2 Store Procedures?
- Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Can STP use VSAM?
[font=Arial]You can use VSAM in DB2 Store Procedures. VSAM files and flat files can be accessed directly by stored procedures, as long as the files are made available to the SPAS with appropriate JCL DD statements. In such cases, the userid associated with the SPAS address space is used to check authorizations. For more details, look here :[/font]
Accessing non-DB2 resources in your stored procedure
Applications that run in a stored procedures address space can access any resources that are available to z/OS® address spaces. For example, they can access VSAM files, flat files, APPC/MVS conversations, and IMS™ or CICS® transactions.
About this task
Accessing these resources from a stored procedure can be useful if you want to update older applications. Suppose that you have existing applications that access non-DB2 resources, but you want to use newer DB2® applications to access the same data. You do not need to rewrite the application or migrate the data to DB2. Instead, you can use stored procedures to execute the existing program or access the non-DB2 data directly.
When a stored procedure runs, the stored procedure uses the Recoverable Resource Manager Services (RRS) for commitment control. When DB2 commits or rolls back work, DB2 coordinates all updates that are made to recoverable resources by other RRS compliant resource managers in the z/OS system.
[font=Arial]PS.: You might have understood by now that such acronyms, which are not universally accepted (like STP), can make confusion. It's good to state them clearly in start.[/font]
Accessing non-DB2 resources in your stored procedure
Applications that run in a stored procedures address space can access any resources that are available to z/OS® address spaces. For example, they can access VSAM files, flat files, APPC/MVS conversations, and IMS™ or CICS® transactions.
About this task
Accessing these resources from a stored procedure can be useful if you want to update older applications. Suppose that you have existing applications that access non-DB2 resources, but you want to use newer DB2® applications to access the same data. You do not need to rewrite the application or migrate the data to DB2. Instead, you can use stored procedures to execute the existing program or access the non-DB2 data directly.
When a stored procedure runs, the stored procedure uses the Recoverable Resource Manager Services (RRS) for commitment control. When DB2 commits or rolls back work, DB2 coordinates all updates that are made to recoverable resources by other RRS compliant resource managers in the z/OS system.
[font=Arial]PS.: You might have understood by now that such acronyms, which are not universally accepted (like STP), can make confusion. It's good to state them clearly in start.[/font]
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute