DB2 Exists 判断表是否存在 以及 动态执行SQL语句

IF NOT EXISTS (SELECT * FROM SYSIBM.SYSTABLES WHERE TID <> 0 AND Name = 'TABLE_NAME' AND Creator  = 'DB2INST1') THEN
		SET 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;