DB2 Exists 判断表是否存在 以及 动态执行SQL语句
IF NOT EXISTS (SELECT * FROM SYSIBM.SYSTABLES WHERE TID <> 0 AND Name = 'TABLE_NAME' AND Creator= 'DB2INST1') THENSET v_Sql = 'CREATE TABLE ' || v_Schema || '.' || v_TabName || ' LIKE ' || v_Schema || '.FTP_Jlkh_Map_Template IN ccp_data';
PREPARE s1 FROM v_Sql;
EXECUTE s1;
SET v_Sql = 'ALTER TABLE ' || v_Schema || '.' || v_TabName || ' ADD PRIMARY KEY(Curr_Date,autoid)';
PREPARE s1 FROM v_Sql;
EXECUTE s1;
END IF;
页:
[1]