analytics/informix/extend/ifxmngr/unprep.sql

drop cast if exists (lvarchar as SYSBldSQLText);
drop cast if exists (sendrecv as SYSBldSQLText);
drop cast if exists (impexp as SYSBldSQLText);
drop cast if exists (impexpbin as SYSBldSQLText);
drop cast if exists (SYSBldSQLText as lvarchar);
drop cast if exists (SYSBldSQLText as sendrecv);
drop cast if exists (SYSBldSQLText as impexp);
drop cast if exists (SYSBldSQLText as impexpbin);

drop function if exists SYSBldSQLTextIn (lvarchar);
drop function if exists SYSBldSQLTextOut (SYSBldSQLText);
drop function if exists SYSBldSQLTextRecv (sendrecv);
drop function if exists SYSBldSQLTextSend (SYSBldSQLText);
drop function if exists SYSBldSQLTextImpT (impexp);
drop function if exists SYSBldSQLTextExpT (SYSBldSQLText);
drop function if exists SYSBldSQLTextImpB (impexpbin);
drop function if exists SYSBldSQLTextExpB (SYSBldSQLText);

drop function if exists Equal (SYSBldSQLText,SYSBldSQLText);

drop function if exists SYSBldPrepare();
drop function if exists SYSBldRegister(CHAR(64), CHAR(18));
drop function if exists SYSBldRegister(CHAR(64));
drop function if exists SYSBldUnregister(CHAR(64), CHAR(18));
drop function if exists SYSBldUnregister(CHAR(64));
drop function if exists SYSBldTrace(CHAR(64), integer);
drop function if exists SYSBldTrace(integer);
drop function if exists SYSBldCleanupTables();
drop function if exists SYSBldRelease();
drop function if exists SYSBldGetSrvrFile(lvarchar, lvarchar);
drop function if exists SYSBldLstBldToPrep();
drop function if exists SYSBldPrepBlade(lvarchar);
drop function if exists SYSBldTstSBSpace(lvarchar);
drop function if exists SYSBldTstVP(lvarchar);
drop function if exists SYSBldLike(SYSBldSQLText, SYSBldSQLText);
drop function if exists SYSBldAddBldDir(lvarchar, lvarchar);
drop function if exists SYSBldPutSrvrFile(lvarchar, lvarchar);
drop function if exists SYSBldGetAnySrvrFile(lvarchar, lvarchar);
drop function if exists SYSBldHTMLTableize(lvarchar, lvarchar);
drop function if exists SYSBldHTMLObjDependents(lvarchar, lvarchar);
drop function if exists SYSBldHTMLObjDependencies(lvarchar, lvarchar);
drop function if exists SYSBldHTMLBldDependencies(lvarchar, lvarchar);
drop function if exists SYSBldHTMLBeginFile(lvarchar, lvarchar);
drop function if exists SYSBldHTMLEndFile(lvarchar);
drop function if exists SYSBldHTMLBldObjs(lvarchar, lvarchar);

-- drop table if exists sysblderrorlog;
drop table if exists sysbldobjects;
drop table if exists sysbldobjdepends;
drop table if exists sysbldobjkinds;
-- drop table if exists sysbldregistered;
drop table if exists sysbldirequired;
drop table if exists sysbldiprovided;
drop view if exists bld_registered;

drop type if exists SYSBldSQLText restrict;