更新时间:2024-12-10 GMT+08:00
ACTIVITYCOUNT
ACTIVITYCOUNT
输入
状态变量,返回嵌入式SQL中受DML语句影响的行数。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
SEL tablename FROM dbc.tables WHERE databasename ='tera_db' AND tablename='tab1'; .IF ACTIVITYCOUNT > 0 THEN .GOTO NXTREPORT; CREATE MULTISET TABLE tera_db.tab1 , NO FALLBACK , NO BEFORE JOURNAL , NO AFTER JOURNAL , CHECKSUM = DEFAULT ( Tx_Zone_Num CHAR( 4 ) , Tx_Org_Num VARCHAR( 30 ) ) PRIMARY INDEX ( Tx_Org_Num ) INDEX ( Tx_Teller_Id ) ; .LABEL NXTREPORT DEL FROM tera_db.tab1; |
输出
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
DECLARE v_verify TEXT ; v_no_data_found NUMBER ( 1 ) ; BEGIN BEGIN v_no_data_found := 0 ; SELECT mig_td_ext.vw_td_dbc_tables.tablename INTO v_verify FROM mig_td_ext.vw_td_dbc_tables WHERE mig_td_ext.vw_td_dbc_tables.schemaname = 'tera_db' AND mig_td_ext.vw_td_dbc_tables.tablename = 'tab1' ; EXCEPTION WHEN NO_DATA_FOUND THEN v_no_data_found := 1 ; END ; IF v_no_data_found = 1 THEN CREATE TABLE tera_db.tab1 ( Tx_Zone_Num CHAR( 4 ) ,Tx_Org_Num VARCHAR( 30 ) ) DISTRIBUTE BY HASH ( Tx_Org_Num ) ; CREATE INDEX ON tera_db.tab1 ( Tx_Teller_Id ) ; END IF ; DELETE FROM tera_db.tab1 ; END ; / |
父主题: 数据操作语句(DML)