SQL Stored procedure call via ODBC

170 pts.
Tags:
IBM DB2
PC/Windows Connectivity
Trying to call a stored procedure via ODBC, the CA400 ODBC driver uses the SQL (as opposed to SYS) conventions this works fine when procedure is created in QGPL and procedure is called with CALL QGPL.MyNewProcedure(Parm1,Parm2,Parm3) when the procedure is in another library then the call does not work CALL MYLIB.MyNewProcedure(Parm1,Parm2,Parm3) message is returned SQL0202 this appears to be something to do with the way the path for the procedure is handled on the SQL naming conventions does anyone know what i need to do to call the stored procedure from windows when it is in a library other than QGPL

Answer Wiki

Thanks. We'll let you know when a new response is added.

The naming convention determines whether slash or dot will be used. Try using a slash instead.

Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Teckgeck
    just to follow up - we have now found the answer to this one... and it is.... update to the latest ODBC drivers there is a problem within the V8 drivers and stored procedures will only run from QGPL, the current (V10) driver works fine
    170 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following