Re: SQL statements in a SQL Stored Procedure.

When you are executing SQL statements in an SQL Stored Procedure do you

to execute any SQL statements dynamically? I assumed you could just

the statements and the compiler would put in the calls automatically. Here
is stored procedure which does not work. It tries to find InSchemaName as

SET PATH "QSYS","QSYS2","SYSPROC","SYSIBMADM","G5DEV" ;
CREATE PROCEDURE G5DEV.DROPDEV (
IN INSCHEMANAME CHAR(10) )
LANGUAGE SQL
SPECIFIC G5DEV.DROPDEV
NOT DETERMINISTIC
MODIFIES SQL DATA
CALLED ON NULL INPUT
SET OPTION ALWBLK = *ALLREAD ,
ALWCPYDTA = *OPTIMIZE ,
COMMIT = *NONE ,
DBGVIEW = *LIST ,
CLOSQLCSR = *ENDMOD ,
DECRESULT = (31, 31, 00) ,
DFTRDBCOL = G5DEV ,
DYNDFTCOL = *NO ,
DYNUSRPRF = *USER ,
SRTSEQ = *HEX
BEGIN
DROP SCHEMA INSCHEMANAME CASCADE ;
END ;

IBM is saying I must execute the DROP statement dynamically. That doesn't
make much sense to me that I would have to do that.