ECAP下db2基本操作
启动db2数据库
导航菜单更新后刷新菜单生效http://104.0.40.111:9080/TxRunAction.do?TranName=clearCacheselect * from t_child_busi_transelect * from t_teller_busiexport to t_child_busi_tran.20100710 of del select * from t_child_busi_tranexport to t_teller_busi.20100710 of del select * from t_teller_busidescribe table t_child_busi_trandescribe table t_teller_busiselect * from t_child_busi_tran where TRAN_CODE like '%0010%'select * from t_child_busi_tran where TRAN_CODE = '_B1_000010'delete from t_child_busi_tran where TRAN_CODE = 'TS_F2_907020'insert into t_child_busi_tran values('代理保险',0,'TS_F2_907020','缴费','G02',2,'0',-1,0,0,'1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111','1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111')insert into t_child_busi_tran values('代理保险',0,'TS_F2_907020','缴费','G03',2,'0',-1,0,0,'1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111','1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111')insert into t_child_busi_tran values('存取开销类',0,'_B1_000010','有折现金存款','G03',2,'0',-1,0,0,'1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111','1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111')数据类型 列列名 模式 数据类型名称 长 小数位 NULL------------------------------- --------- ------------------- ---------- ----- ------CHILD_BUSI_NAME SYSIBM VARCHAR 50 0 否 子业务名称CHILD_BUSI_ID SYSIBM BIGINT 8 0 否TRAN_CODE SYSIBM CHARACTER 50 0 否 交易码TRAN_NAME SYSIBM CHARACTER 50 0 否 交易名称TELLER_BUSI_NO SYSIBM VARCHAR 20 0 否 所属业务IDTRAN_SEQ SYSIBM BIGINT 8 0 否 交易序号TRAN_TYPE SYSIBM CHARACTER 1 0 是 交易类型F_AUTHLEVEL SYSIBM INTEGER 4 0 否IS_FINATRAN SYSIBM INTEGER 4 0 否IS_CORRTRAN SYSIBM INTEGER 4 0 否AUTH_GROUP SYSIBM VARCHAR 200 0 是 柜组AUTH_BRANCH SYSIBM VARCHAR 200 0 是列名 模式 数据类型名称 长 小数位 NULL------------------------------- --------- ------------------- ---------- ----- ------TELLER_BUSI_NO SYSIBM INTEGER 4 0 否TELLER_BUSI_NAME SYSIBM VARCHAR 40 0 否TELLER_BUSI_STAT SYSIBM CHARACTER 1 0 否TELLER_BUSI_DETAIL1 SYSIBM VARCHAR 1024 0 是TELLER_BUSI_DETAIL2 SYSIBM VARCHAR 1024 0 是TELLER_BUSI_DETAIL3 SYSIBM VARCHAR 1024 0 是TIME_SIGN SYSIBM BIGINT 8 0 否STR_RESERVE1 SYSIBM VARCHAR 255 0 是STR_RESERVE2 SYSIBM VARCHAR 255 0 是DAC SYSIBM CHARACTER 16 0 是update t_teller_busi set TELLER_BUSI_NAME = '禅城特色支付业务' where TELLER_BUSI_DETAIL1 = 'G16'update t_teller_busi set TELLER_BUSI_NAME = '禅城中间业务' where TELLER_BUSI_DETAIL1 = 'G15'