Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Run Procedure object in DB2 Express 9.5
Run Procedure object in DB2 Express 9.5 [message #593621] Tue, 21 October 2008 14:12
Flavio Ricci is currently offline Flavio RicciFriend
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"
Previous Topic:Run Procedure object in DB2 Express 9.5
Next Topic:standalone sync plugin
Goto Forum:
  


Current Time: Wed Nov 26 13:17:07 GMT 2014

Powered by FUDForum. Page generated in 0.02760 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software