execute Stored Procedure using Developer Work Bench

Al Goodman

execute Stored Procedure using Developer Work Bench
I attempted to invoke a Cobol Stored Procedure using Developer Work Bench
and received the following log information........

DEVLDGLN is a schema name and not the RACF ID a logged on with......

I cannot understand what the error message is attempting to state......

Please assist......

Thanks


******************************************************
DEVLDGLN.GLN_GLNRFTST - Run started.

DEVLDGLN.GLN_GLNRFTST - Exception occurred while running:
DEVLDGLN SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS

DEVLDGLN.GLN_GLNRFTST - Roll back completed successfully.

DEVLDGLN.GLN_GLNRFTST - Run failed.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Myron Miller

Re: execute Stored Procedure using Developer Work Bench
(in response to Al Goodman)
You are attempting to call the procedure devldgln.gln_glnrftst. And devldgln doesn't exist as a valid schema.

For example, you might have issued the following call:
call test.sp1. TEST is the schema name and sp1 is the sp name.

For some reason, your schema (stored procedure qualifier) is defaulting to devldgln in Developer work bench. Not sure why. Check to see what your qualifier defaults are when accessing things.

Myron



________________________________
From: Al Goodman <[login to unmask email]>
To: [login to unmask email]
Sent: Monday, January 12, 2009 11:08:49 AM
Subject: [DB2-L] execute Stored Procedure using Developer Work Bench

I attempted to invoke a Cobol Stored Procedure using Developer Work Bench
and received the following log information........

DEVLDGLN is a schema name and not the RACF ID a logged on with......

I cannot understand what the error message is attempting to state......

Please assist......

Thanks


******************************************************
DEVLDGLN.GLN_GLNRFTST - Run started.

DEVLDGLN.GLN_GLNRFTST - Exception occurred while running:
DEVLDGLN SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS

DEVLDGLN.GLN_GLNRFTST - Roll back completed successfully.

DEVLDGLN.GLN_GLNRFTST - Run failed.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html