Re: QZDASOINIT Jobs

Pete Helgren


Rich Duzenbury wrote:

On Mon, 2006-01-09 at 08:39 -0800, Coy Krill 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;

Hmm.  'SQL allows remote command execution' sounds suspiciously like
something we would normally read about on the CERT web site.  This is a

feature?

What has to be done to turn it off?

Regards,
Rich