January 9, 2002 01:55 PM
(in response to Buz W)
You can create stored procs without WLM. Are you sure your create
stmt was correct? Here's a copy of a create in V6 on os/390 machine
that does work fine.
CREATE PROCEDURE XXXXX.FHSC_DATE_ROUTINE
(INOUT VARIN CHAR(164) ) -- FOR BIT DATA)
EXTERNAL NAME CNVDT
NO WLM ENVIRONMENT
PROGRAM TYPE MAIN
STAY RESIDENT YES
PARAMETER STYLE GENERAL
READS SQL DATA
>>> [login to unmask email] 01/09/02 02:14PM >>>
I'm trying to create a stored procedure in a DB2 v6 environment
that has no WLM regions defined. I'm using NO WLM ENVIRONMENT, but
the message I get back is "DSNT408I SQLCODE = -592, ERROR: NOT
AUTHORIZED TO CREATE FUNCTIONS OR PROCEDURES IN WLM ENVIRONMENT NO
WLM ENVIRONMENT"; which is odd since I'm a SYSADM.
I know it's best to use WLM. I'm working on a client system and
they don't have WLM (yet). I can't very well tell them I won't
continue the project until WLM is in place.
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.
This message, including any attachments, is intended solely for the
use of the named
recipient(s) and may contain confidential and/or privileged
unauthorized review, use, disclosure or distribution of this
communications is expressly
prohibited. If you are not the intended recipient, please contact
the sender by reply e-mail
and destroy any and all copies of the original message. Thank