Topic
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