IBM Mainframe Forum

Hi all
i want to call a stored procedure from a cobol module
i am using following way to achieve that but i am getting sql error -444 (user program could not be found)

EXEC SQL
CALL <SP_NAME> (:LS-INPUT,
:LS-OUTPUT)
END-EXEC

I have compiled the SP module as C37NSP31module

It sounds like you forgot the CONNECT call
EXEC SQL
CONNECT TO dev (WHATEVER)
END EXEC

then perform your call. Remember do not check for SQLCODE = ZERO. Check for sqlcode +466 instead and comtinue processing.

These users thanked the author pmartyn for the post:

pulsar22 (Wed Sep 25, 2013 9:07 pm)