thanks marc,
Yea the DB2 subsystem is called DSN.
I defined the STORED PROCEDURE with a COLLID and I have the plan TSTCAP3 defined with that COLLID and Bound both the main program and the STORED PROCEDURE program using that COLLID.
Here is the Clist that I use to call TSTCAP3. TSTCAP3 is a PLI program that calls the Stored Procedure which is another PLI Program. The clist didn't paste onto this message board very well for whatever reason but here it is.
CONTROL MSG CONLIST NOFLUSH NOPROMPT SYMLIST...
I get a -927 on the Mainframe (MVS) when running a stored procedure. Any ideas ? I've read the message in Messages and Codes and have SDSNLOAD in my iSPLLIB in the CLIST I'm usning to call the Main program. The DSNSPAS has a SDSNLOAD library in it's JCL also.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.