I have a few Stored Procedures for my application (DB2 V 9.7.3). I need to rebind the packages corresponding to the Stored Procedures. I wish to get having them recompiled inside a Stored Procedure by retrieving the package names via a Cursor and rebind the packages one by one.
The command to do is
REBIND PACKAGE <schema>.<pkgName>
To execute this command, I tried the following options but both of them failed.
EXECUTE IMMEDIATE <stmt>; CALL SYSPROC.ADMIN_CMD(<stmt>);
Is there a way to get this accomplished? Any help would be highly appreciated.