View previous topic :: View next topic
|
Author |
Message |
nareshkareti
New User
Joined: 22 Jul 2008 Posts: 33 Location: Chennai
|
|
|
|
In the code mentioned in the REXX program
Code: |
PROC = 'SYSPROC.ADMIN_INFO_SYSPARM1'
ADDRESS DSNREXX 'EXECSQL CALL ' PROC,
'(:SSID :SSID_IND',
',:RETCD :RETCD_IND',
',:MSSG :MSSG_IND)' |
I want to know how the SP is stored in the 'SYSPROC.ADMIN_INFO_SYSPARM1. I dont think this is a dataset. so what exactly is this? I am a novice in SQL SP.. Please help |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
nareshkareti wrote: |
Where can I see the details of the proc
PROC = 'SYSPROC.ADMIN_INFO_SYSPARM1'
I mean how the data inside the above proc is stored? |
In a thread that is not tagged on to a two-year-old one |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
As Akatsukami has stated, DO NOT tag unrelated questions onto a long deceased thread.
Now, answer one simple question. How the hell are we supposed to know how your site has been set up.
Have you considered asking someone in your DB2 team this question |
|
Back to top |
|
|
nareshkareti
New User
Joined: 22 Jul 2008 Posts: 33 Location: Chennai
|
|
|
|
Thanks for creating a new thread..
Somehoe i managed to get the REXX code to execute a proc.
Managed to write a SQL Stored procedure..
Now I dont know how to relate them and execute. Where shud I store the SQL SP and refer it in REXX? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Ask the support / DB2 people at YOUR site |
|
Back to top |
|
|
|