I guess this should solve your problem.. When you submit the job using SBMJOB command, look for the additional parameters... One of them is "INLLIBL". Please use the parameter for this as "*JOBD". This may have default value as "*CURRENT". This could be the solution for your problem. (Embedded image moved to file: pic10104.pcx) Thanks Shailu "Al Heitkamp" <Al.Heitkamp@hbfuller.com>@midrange.com on 08/23/2000 08:02:23 AM Please respond to JAVA400-L@midrange.com Sent by: email@example.com To: Java400-L@midrange.com cc: Subject: Native JDBC Driver and Library List Problems I have two java jobs that I submit to batch that call stored procedures. Each needs a different library list. I setup a job description for each job with the appropriate library lists. The SBMJOB commands I use are: SBMJOB CMD(CALL PGM(STERMB01/MF4000CL)) JOB(MF4000CL) JOBD(HEITKA01/AAHJOBD) SBMJOB CMD(CALL PGM(HEITKA01/IMINTCL)) JOB(IMINTCL) JOBD(HEITKA01/IMINT) It appears that the stored procedures get the library list of the job description that my user profile points to instead of picking up the library list from the JOBD parameter on the SBMJOB command. If I set the job description for my user profile before I submit the job it works fine, but this is very cumbersome and would not work well in production unless we set up separate user profiles for each job. We are running V4R4 of the OS and Java 1.1.7. Has anyone else encountered similar issues? Thanks, Alan A. Heitkamp H.B. Fuller Company (651) 236-4072 Al.Heitkamp@hbfuller.com +--- | 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: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.