View previous topic :: View next topic |
Author |
Message |
vmbigot Beginner

Joined: 17 Jun 2004 Posts: 36 Topics: 14 Location: westminster, california
|
Posted: Wed Apr 19, 2006 11:20 am Post subject: vsam files in stored procedures |
|
|
We want to access VSAM files from within COBOL DB/2 stored procedures. The DB2 manual states that you have to add DD statements to the SPAS or WLM address space for each VSAM file that the stored procedure(s) are going to access. I am not comfortable with the idea of adding user application files to system procs. Is there another way for a COBOL DB/2 stored procedure to access VSAM files without requiring hard-coded DD cards in the SPAS or WLM address space where the stored procedure executes?
vmbigot _________________ Inside every older man is a young boy asking this question. What the heck happened?!? |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Wed Apr 19, 2006 12:13 pm Post subject: |
|
|
Quote: |
Is there another way for a COBOL DB/2 stored procedure to access VSAM files without requiring hard-coded DD cards in the SPAS or WLM address space where the stored procedure executes?
|
Unfortunately NO.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
vmbigot Beginner

Joined: 17 Jun 2004 Posts: 36 Topics: 14 Location: westminster, california
|
Posted: Wed Apr 19, 2006 12:30 pm Post subject: |
|
|
That's what I was afraid of. Thanks for the quick reply.
vmbigot _________________ Inside every older man is a young boy asking this question. What the heck happened?!? |
|
Back to top |
|
 |
|
|