| Run Procedure object in DB2 Express 9.5 [message #51065] |
Tue, 21 October 2008 14:12 |
 Flavio Ricci
Messages: 2
Registered: July 2009 |
Junior Member |
|
|
I tried to run a Procedure Object named BONUS_INCREASE (SAMPLE is the
database name) and the dtp didn't show me the "Configure Parameters"
dialog panel. The procedure has two input parameters. The run went in
error with the following message:
<code>
call SAMPLE.OYM.BONUS_INCREASE
The name "BONUS_INCREASE" has the wrong number of qualifiers. SQLCODE
-108, SQLSTATE=42601, DRIVER=3.50.152
</code>
It doesn't make sense that call uses the name of database before the
schema.
It would be like call OYM.BONUS_INCREASE (<i>parameters..</i>) where OYM
is my schema and not like call SAMPLE.OYM.BONUS_INCREASE.
In my opinion the Configure Parameters dialog panel doesn't appear because
SAMPLE.OYM.BONUS_INCREASE doesn't exists but OYM.BONUS_INCREASE exists.
For the DB2 SQL Language for calling a stored procedure the right
procedure signatures is a procedure identified by its schema, name, and
the number of parameters like
<i>schema</i>.<i>name_procedure</i>(<i>?,?,?...</i >).
Has anyone any idea?
Anyway, thanks for your attention.
<hr>
The configuration is:
- eclipse-j2ee-ganymede-SR1-win32 with "dtp" version 1.6.1
- DB2 Express 9.5
The steps was
- In the "Preferences"."Driver Definitions" i added a new "IBM Data Server
for JDBC and SQLJ" for "DB2 for Linux, UNIX, Windows" for the only listed
System Version 9.1 and using the right jar driver contained in the DB2
installation
- I created a new "Connection Profile" with SAMPLE database using the
driver used above
- I expanded the schema in the SAMPLE database tree under the "Data Source
Explorer", and i chose the Procedure Object used above
- Then "Run"."Run as"."SQL Routine"
|
|
|
Powered by
FUDForum. Page generated in 0.02966 seconds
] 
Search
Help
Register
Login
Home
