SELECT COLCOUNT INTO :snbr FROM SYSIBM.SYSTABLES WHERE CREATOR = 'SYSIBM' AND NAME='SYSTABLES'
DECLARE c2 CURSOR FOR SELECT SECTION, SECTNO, SEQNO FROM SYSIBM.SYSSECTION WHERE PLNAME = :planname AND PLCREATOR = :creator AND SECTNO BETWEEN :snbr AND :snbr2 ORDER BY SECTNO, SEQNO
OPEN c2
SELECT VALID INTO :valid FROM SYSIBM.SYSPLAN WHERE CREATOR = :creator AND NAME = :planname
FETCH c2 INTO :section, :sectno, :seqnbr
DECLARE c3 CURSOR FOR SELECT TEXT, SEQNO FROM SYSIBM.SYSSTMT WHERE PLCREATOR = :creator AND PLNAME = :planname AND SECTNO = :oldsectno ORDER BY SEQNO
OPEN c3
FETCH c3 INTO :stmt, :seqnbr2
CLOSE c3
CLOSE c2
SELECT CREATOR, NAME INTO :icreator, :iname FROM SYSIBM.SYSINDEXES WHERE TBCREATOR = :tbcreator AND TBNAME = :tbname AND IID = :iid
SELECT CREATOR, NAME INTO :tbcreator, :tbname FROM SYSIBM.SYSTABLES WHERE FID = :fid