Re: Native JDBC Driver and Library List Problems

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