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
when the procedure is in another library then the call does not work
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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!