Re: stored procedure error - sql0443n - sqlstate=38501

On Apr 8, 2005 2:13 PM, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> CHGJOB of that job to increase logging levels do anything?
> STRSRVJOB, TRCJOB, help find the missing service program?
> However, it sounds like you should have enough data that IBM should now be
> able to figure it out.

I gave it a little effort and  made some headway.  I had the RPG
stored procedure SNDMSG to a msgq so I could tell what job was
running.  Job name QRWTSRVR, user QUSER.  Commands in the RPG like
chgjob log(4 0 *seclvl) logclpgm(*yes) were ignored. Printed output
was produced under a 2nd job, qprtjob, with the user profile from my
sql connection string.   I still dont know how the QRWTSRVR job can be
made to have the correct library list so the service program can
loaded.

-Steve