Re: QZDASOINIT Jobs

[Sarah Poger Gladstone <listmember@xxxxxxxxxxxxxx>]

I would suggest changing WIBRUN to an alias name that does not match a
physical library name. Also it is not necessary to include the library
"QSYS" on the external name parameter, that way the *LIBL of the user
profile will be used to locate the program.

For more info about aliases and calling stored procs from the *LIBL
check out the article:
http://www.ignite400.org/news/pdf/news2003031001.pdf

-Sarah Poger Gladstone



On 1/9/06, Coy Krill <coyk@xxxxxxxxxx> wrote:
> Here is the SQL code you can execute either via JDBC or directly on the
> iseries. I've never tried calling QCMDEXC  and was definitely under the
> impression that a wrapper such as this is necessary. I believe this is close
> to nearly identical to something published in one of the iSeries reference
> manuals or a redbook. Change WIBRUN to be whatever library you want to
> create the stored procedure in.
>
> -- Allows Execution of CL Commands from SQL
> CREATE PROCEDURE WIBRUN.CMDEXC(CMD CHAR(32000), LEN DECIMAL(15, 5))
> LANGUAGE CL
> NOT DETERMINISTIC
> NO SQL
> EXTERNAL NAME QSYS.QCMDEXC
> PARAMETER STYLE GENERAL;
>
>
> Coy Krill
> Systems Analyst
> Whidbey Island Bank
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Anand, Rajesh
> Sent: Monday, January 09, 2006 00:32
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: QZDASOINIT Jobs
>
> Paul,
>
>        This is very interesting, how would I go about adding JDBC stored
> procedure??
>
>        Can you list the steps involved or link to some detailed info??
>
>        Many Thanks,
>
> Rajesh Anand
> Email:Rajesh_anand@xxxxxx
>
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Holm
> Sent: 06 January 2006 18:47
> To: java400-l@xxxxxxxxxxxx
> Subject: Re: QZDASOINIT Jobs
>
>
>
>
> You should also be able to use something like this as the JDBC stored
> procedure call:
>
> CALL QSYS.QCMDEXEC('SNDPGMMSG("Pgm x calling")', 0000000026.00000)
>
> Where 26 is the length of the command.
>
> This may provide benefits:
> *  Ability to pass ANY cl command to the JDBC SQL connection such as
> OVRDBF,etc
>
> *  Create a little utility that takes a command and builds the call qcmdexec
> SP call string generically
>
> *  Doesn't require a special CL for each command
>
>
> If had this on my list of things to try.  I don't see why it would not work.
>
>
> HTH - Paul Holm
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.14.14/222 - Release Date:
> 1/5/2006
> --------------------------------------------------------
>
> If you are not an intended recipient of this e-mail, please notify the
> sender, delete it and do not read, act upon, print, disclose, copy, retain
> or redistribute it. Click here for important additional terms relating to
> this e-mail.     http://www.ml.com/email_terms/
> --------------------------------------------------------
>
> --
> 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.
>
> ************************************************************************
> The information in this e-mail is confidential and may be legally
> privileged. It is intended solely for the addressee. Access to
> this e-mail by anyone else is unauthorized. If you are not the
> intended recipient, any disclosure, copying, distribution or any
> action taken or omitted to be taken in reliance on it, 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.
>
>