Re: QZDASOINIT Jobs

[Sarah Poger Gladstone <listmember@xxxxxxxxxxxxxx>]

Nigel- One way is to write a stored procedure or user-defined
function. Then call the stored procedure or user-defined function from
Java, using the same JDBC connection that you are planning to use for
your query.  The only downside to this is you would have to do a code
review to enforce that all Java programs using JDBC did this.

HTH,
Sarah Poger Gladstone


On 1/5/06, NGay@xxxxxxxxxxxxx <NGay@xxxxxxxxxxxxx> wrote:
> > I'd argue that using WRKODBCJOB is MUCH easier.  Sure you can use
> > WRKACTJOB JOB(QZDASOINIT) and then laboriously step through each job to
> > see who the user is that is being serviced, or you can just use
> > WRKODBCJOB and SEE who the serviced user is without looking at the job
> > log.  I LOVE this utility!
> >
> > However, to get calling application information into the job log you
> > could just call a CL program from your app that simply outputs that
> > information (Passing the application function as a parameter perhaps).
>
> Pete,
>
> How would this work?  If I have a Java program making an SQL connection to
> one of the iSeries, and this uses the toolbox/PCML to call a CL program,
> that CL program will execute in the Remote Command Daemon job, QZRCSRVSD.
> Any messages that the CL outputs (presume you mean using SNDPGMMSG) will
> appear there, not in the QZDASOINIT job.  Is there any way from Java to
> make a message appear in the QZDASOINIT job log?
>
> Thanks very much,
>
> Nigel Gay,
> Computer Patent Annuities.
>
>
>
> ********************************************************************************
> The information in this message is confidential and may be legally
> privileged. It is intended solely for the addressee; access to this
> email by anyone else is unauthorised.
>
> If you are not the intended recipient: (1) you are kindly requested
> to return a copy of this message to the sender indicating that you
> have received it in error, and to destroy the received copy; and (2)
> any disclosure or distribution of this message, as well as any action
> taken or omitted to be taken in reliance on its content, is prohibited
> and may be unlawful.
> ********************************************************************************
>
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>