Re: Native JDBC Driver and Library List Problems

["Al Heitkamp" <Al.Heitkamp@xxxxxxxxxxxx>]

Thanks to Arlene Soderlund for her suggestion but unfortunately,  it does not 
correct my problem.  The command I used is as follows:

SBMJOB CMD(CALL PGM(HEITKA01/IMINTCL)) JOB(IMINTCL) JOBD(HEITKA01/IMINT) 
INLLIBL(*JOBD)

Using WRKACTJOB, I verified that the IMINTCL job has the correct library list.  
In addition I also verified that the QJVACMDSRV job that is spawned also has 
the correct library list.  My java program calls DB2 stored procedures, so a 
third job called QSQSRV running as QUSER is spawned and I suspect that this is 
the component that is not getting the library list from what is specified on 
the SBMJOB command.  I get error CPF4101 because the stored procedure is trying 
to access a file not in the library list. The QSQSRV job does not appear in the 
WRKACTJOB list when this error occurs so I can not actually see the library 
list.

If I change my user profile to point the job description using "CHGUSRPRF 
USRPRF(HEITKA01) JOBD(HEITKA01/IMINT)", then submit the job it works fine.

Any help would be greatly appreciated.

Thanks,


Alan A. Heitkamp
H.B. Fuller Company
(651) 236-4072
Al.Heitkamp@hbfuller.com


>>> "Arlene M Soderlund" <Arlene_M_Soderlund/NFCNA.COM@nfcna.com> 08/23/00 
>02:33PM >>>








"Al Heitkamp" <Al.Heitkamp@hbfuller.com> on 08/23/2000 10:02:23 AM


SBMJOB CMD(CALL PGM(STERMB01/MF4000CL)) JOB(MF4000CL) JOBD(HEITKA01/AAHJOBD)
INLLIBL(*JOBD)
SBMJOB CMD(CALL PGM(HEITKA01/IMINTCL)) JOB(IMINTCL) JOBD(HEITKA01/IMINT)
INLLIBL(*JOBD)


add Inllibl to the submitt






+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net 
+---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---