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:  owner-java400-l@midrange.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: joe@zappie.net
+---

Paintbrush


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.