Member_2_2484401
asked on
errors when creating a stored procedure on DB2 for z/OS
Greetings!
As I make my transition from working on "DB2 for I" to "DB2 for z/OS", I'm finding subtle differences that are tripping me up.
For example, I copied the following simple stored procedure from a website:
But, when creating the procedure, it throws the following error:
WLM ENVIRONMENT NAME MUST BE SPECIFIED
I googled that error, and it was recommended that I add "DISABLE DEBUG MODE":
But, it now throws these errors:
REBIND AUTHORIZATION ERROR USING MYSCHEMA AUTHORITY PACKAGE =
LOCDBT1.MYSCHEMA.UPDATE_SA LARY_1.(V1 ) PRIVILEGE = BIND.
What am I doing wrong?
Thanks for your help!
DaveSlash
As I make my transition from working on "DB2 for I" to "DB2 for z/OS", I'm finding subtle differences that are tripping me up.
For example, I copied the following simple stored procedure from a website:
CREATE PROCEDURE MYSCHEMA.UPDATE_SALARY_1 (
IN EMPLOYEE_NUMBER CHAR(10),
IN RATE NUMERIC(6,2))
LANGUAGE SQL
MODIFIES SQL DATA
UPDATE MYSCHEMA.EMP
SET SALARY = SALARY * RATE
WHERE EMPNO = EMPLOYEE_NUMBER
But, when creating the procedure, it throws the following error:
WLM ENVIRONMENT NAME MUST BE SPECIFIED
I googled that error, and it was recommended that I add "DISABLE DEBUG MODE":
CREATE PROCEDURE MYSCHEMA.UPDATE_SALARY_1 (
IN EMPLOYEE_NUMBER CHAR(10),
IN RATE NUMERIC(6,2))
LANGUAGE SQL
MODIFIES SQL DATA
DISABLE DEBUG MODE
UPDATE MYSCHEMA.EMP
SET SALARY = SALARY * RATE
WHERE EMPNO = EMPLOYEE_NUMBER
But, it now throws these errors:
REBIND AUTHORIZATION ERROR USING MYSCHEMA AUTHORITY PACKAGE =
LOCDBT1.MYSCHEMA.UPDATE_SA
What am I doing wrong?
Thanks for your help!
DaveSlash
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER