View previous topic :: View next topic
|
Author |
Message |
madhu_910
New User
Joined: 21 Feb 2005 Posts: 10
|
|
|
|
Can anyone tell where are stored procedures stored?
Rgds,
Madhu |
|
Back to top |
|
|
Karthikt
New User
Joined: 15 Aug 2005 Posts: 51
|
|
|
|
Stored procedures are stored in DB2 subsystem controlled by work load manager |
|
Back to top |
|
|
rameshchikkon
New User
Joined: 18 Aug 2005 Posts: 1
|
|
|
|
hi DB2 stored procedures are stored in sysibm.sysproc system tables |
|
Back to top |
|
|
madhu_910
New User
Joined: 21 Feb 2005 Posts: 10
|
|
|
|
Thanks karthik & ramesh for your information |
|
Back to top |
|
|
selva_great
New User
Joined: 22 Aug 2005 Posts: 1
|
|
|
|
Stored Procedures can be found in SYSIBM.SYSROUTINES. |
|
Back to top |
|
|
madhu_910
New User
Joined: 21 Feb 2005 Posts: 10
|
|
|
|
To be frank I am confused with the answers
Pls confirm me the right answer.
To be clear again are the stored procedures got saved in some particular
pds or they can be saved anywhere as per our convenience?
----------------
Madhu |
|
Back to top |
|
|
nandump3
New User
Joined: 11 Aug 2005 Posts: 1 Location: India
|
|
|
|
DB2 stored procedures are stored in sysibm.sysproc system tables. procedure are stored in PDS only |
|
Back to top |
|
|
|