RE: QZDASOINIT Jobs

Hmmm, that's an interesting idea. I've run in to this problem myself and
this seems to solve it. Thanks for the link. On the use of QSYS, that's my
unix background coming through. I don't want just any QCMDEXC be used, I
ONLY want the one from QSYS so that was definitely intentional. I'm going to
start aliasing all my stored procedures though, thanks again!


Coy Krill
Systems Analyst
Whidbey Island Bank 
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Sarah Poger Gladstone
Sent: Monday, January 09, 2006 09:01
To: Java Programming on and around the iSeries / AS400
Subject: Re: QZDASOINIT Jobs

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.
>
>

--
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.