Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
33 Posts
ACCEPTED ANSWER

Pinned topic Problem using ADMIN_DROP_SCHEMA

‏2012-01-03T15:51:19Z |
Hello,
I'm using some DB2 maintenance procedures like SYSPROC.ADMIN_DROP_SCHEMA. If they have input/output parameters they do not work in IBM Optim Database Administrator.

In DB2 Command Window/DB2 CLP it is ok:

CALL SYSPROC.ADMIN_DROP_SCHEMA('TESTF3', NULL, 'TESTF1', 'ERRORTABLE')
Value of output parameters

Parameter Name : ERRORTABSCHEMA
Parameter Value : TESTF1

Parameter Name : ERRORTAB
Parameter Value : ERRORTABLE

Return Status = 0

But when I run it from the script editor I get the error:

The parameter mode OUT or INOUT is not valid for a parameter in the routine named "ADMIN_DROP_SCHEMA" with specific name "ADMIN_DROP_SCHEMA" (parameter number "3", name "ERRORTABSCHEMA").. SQLCODE=-469, SQLSTATE=42886, DRIVER=3.61.65

Is it possible to run it from here somehow?

Thanks,
Dirk