DB2
程序媛小方
这个作者很懒,什么都没留下…
展开
-
DB2清空表数据存储过程
调用 call BSDCMACW.P_TRUNC_TABLE('BSDCMACW','T_ADS_FACT_CWMO_0010'); 清空表数据 SET CURRENT SCHEMA = "bsdcmacw"; SET CURRENT PATH = SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,BSDCMACW; CREATE OR REPLACE PROCEDURE BSDCMACW.P_TRUNC_TABLE ( IN P_OWNER VARCHAR(32), I原创 2021-02-04 09:40:15 · 525 阅读 · 0 评论 -
DB2创建伪表存储过程
调用示例 call BSDCMACW.P_CREATE_TEMP_TABLE('BSDCMACW','test12','01','select * from bsdcmacw.T_ADS_FACT_CWMO_0010'); 创建伪表 SET CURRENT SCHEMA = "bsdcmacw"; SET CURRENT PATH = SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,BSDCMACW; CREATE OR REPLACE PROCEDURE BSDCMACW.P_CRE原创 2021-02-04 09:32:16 · 334 阅读 · 1 评论