View previous topic :: View next topic |
Author |
Message |
ashutosh_agl3 Beginner
Joined: 14 Aug 2003 Posts: 28 Topics: 15
|
Posted: Tue Apr 13, 2004 10:47 am Post subject: setting sqlid dynamically |
|
|
How can we set the sqlid dynamically during execution of programme
knowing no other parameters to fetch SYS tables |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Apr 13, 2004 10:56 am Post subject: |
|
|
ashutosh_agl3,
You can set the SQLID using the following statement.Do not include the SET CURRENT SQLID statement in your stored procedure.
Code: |
EXEC SQL
SET CURRENT SQLID = 'ABC'
END-EXEC
|
Check this link for a detailed explanation of SET CURRENT SQLID
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
ashutosh_agl3 Beginner
Joined: 14 Aug 2003 Posts: 28 Topics: 15
|
Posted: Tue Apr 13, 2004 12:23 pm Post subject: |
|
|
sORRY THAT DIDNT HELP..the question is like when i dont know the DB2 qualifier(sop i cannot use SET CURRENT SQLID) and want to set it dynamically based on certain CICS refion, then how can i do it? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|