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:

The name "BONUS_INCREASE" has the wrong number of qualifiers. SQLCODE
-108, SQLSTATE=42601, DRIVER=3.50.152
It doesn't make sense that call uses the name of database before the

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

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.


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
- 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: Thu Apr 26 04:19:10 GMT 2018

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

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