View previous topic :: View next topic
|
Author |
Message |
valeti_sashi
New User
Joined: 23 Jun 2006 Posts: 7
|
|
|
|
Hi,
i had created a pure SQL stored procedure in DB2. Now the question is how to build/compile it. is there any command in SQL itself like Compile in oracle or do we have to use a JCL compiler for binding it. it if we have to use the JCL compiler, please send me the send also.
please help me in this concerns.
regards,
sashidhar |
|
Back to top |
|
|
IbmBoy
New User
Joined: 16 Sep 2006 Posts: 1 Location: Cranberry Twp., PA
|
|
|
|
I am new to this, but I am using WinSQL to attach to and create/edit my stored procedures. |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
If you have created an internal db2 Sql stored procedure, run it on the SPUFI(I am assuming that you are using z/os or os390) with create procedure statement and embed the sql procedure within a begin and end clause. If the SPUFI run is successful, you can check the SYSIBM.SYSROUTINES table and find your procedure there. |
|
Back to top |
|
|
valeti_sashi
New User
Joined: 23 Jun 2006 Posts: 7
|
|
|
|
anamikak,
i know how to create and run a procedure, but after creating and before executing we should compile and bind the procedure. i want the procedure to compile.
plesse let me know if u have worked on it. |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
Do a normal db2 precompile using a standard JCL and do a package bind on the resulting DBRM. |
|
Back to top |
|
|
valeti_sashi
New User
Joined: 23 Jun 2006 Posts: 7
|
|
|
|
anamikak,
can u give the jcl that does the precompilation step.
thanks in advance. |
|
Back to top |
|
|
satya123 Warnings : 1 New User
Joined: 18 Aug 2006 Posts: 57
|
|
|
|
please send me some examples of stored proc and its process...
Please |
|
Back to top |
|
|
|