creating stored procedures

[balachandar]

Hi All,
Is there any way create a stored procedure with out using stored procedure builder. The builder is very slow and hangs more often than not when I am using a remote connection. Hence I would like to know if I can build a procedure using control center or command center or dos prompt ?.
Thanks and Regards
Balachandar Ganesan.

 

[Shaixpeare]

You can create your stored procedure any way you like as long as it's supported by DB2. However, you need to be able to get the binary code into the DB2 function path on the server. After you do that, you can simply catalog the procedure using the DB2 Command Center or Dos command prompt. However, I would check to see which version of the DB2 Stored Procedure Builider you are using. Chances are you're a couple of fixpaks behind. The SPB and GUI tools in general have all had lots of their bugs fixed with the last few fixpaks.

 

[balachandar]

Hi,
Thanks for the response. But I would like to know how this can be done. I am currently using Version 7.2. Where can I get the service packs.
Balachandar Ganesan

 

[sandips]

Hi,
I am trying to create a stored procedure from DB 8.0 control center and I am getting the following error.

SQL0104N An unexpected token "END-OF-STATEMENT" was found
following "END P1 ". Expected tokens may include: "JOIN
<joined_table>

However the same procedure can be created using the development center procedure builder utility.

The control center is giving hints like this

&quot;Explanation:
A syntax error in the SQL statement was detected at the specified token following the text &quot;<text>&quot;. The &quot;<text>&quot; field indicates the 20 characters of the SQL statement that preceded the token that is not valid. &quot;

Looking forward to your suggestions.

Regards
Sandip