%w[ ORDER BY {%c[%i][%r DESC],}][ FOR UPDATE OF {%u,}]
DELETE FROM %t WHERE CURRENT OF [%k]
DELETE FROM %t[ WHERE %w]
UPDATE %t SET {%c=%v,} WHERE CURRENT OF [%k]
UPDATE %t SET {%c=%v,}[ WHERE %w]
INSERT INTO %t[ ({%c,})] VALUES ({%v,})
SELECT T.NAME,T.REMARKS,T.COLCOUNT,T.TYPE,'',T.CREATOR,C.COLTYPE,C.LENGTH,C.NULLS,C.NAME,C.REMARKS,'',C.SCALE FROM SYSIBM.SYSTABLES T,SYSIBM.SYSCOLUMNS C WHERE T.NAME=C.TBNAME AND T.NAME= %n[ AND T.CREATOR=%o][%r AND T.CREATOR=USER]
SELECT NAME,REMARKS,COLCOUNT,TYPE,'',CREATOR FROM SYSIBM.SYSTABLES[ WHERE CREATOR=%o][%r[%b WHERE CREATOR = [%d][%rUSER%r]%r]%r][ [%rAND][%rWHERE] NAME = %n]
SELECT COLTYPE,LENGTH,NULLS,NAME,REMARKS,'',SCALE,CODEPAGE,COLNO FROM SYSIBM.SYSCOLUMNS WHERE TBNAME= %n AND TBCREATOR=%o[ AND NAME = %s] ORDER BY COLNO
SELECT %s FROM [%o.]%n
%z!TCCOMMIT
%z!TCROLLBACK
%z!TCABORT
CREATE TABLE %t ({%x,}[ ,%e])
%n %f[%b NOT NULL][ %e]
CREATE VIEW %t [({%x,})] AS %w[%b WITH CHECK OPTION][ %e]
%n
%n %f[ %e]
CREATE [%bUNIQUE ]INDEX %n ON %t({%c[%i][%r DESC],})[ %e]
