--监控某个表,当数据插入到表后,执行触发。
CREATE trigger tri_ins_UB_ORGINFO
after INSERT ON UB_ORGINFO
--for insert
REFERENCING NEW AS n
FOR EACH ROW --MODE DB2SQL
BEGIN ATOMIC
delete from UB_ORGINFO_HK;
insert into UB_ORGINFO_HK (
SELECT I_ID as ibankid, S_DISPLAYNAME as SBANKNAME,PBCBIGAREABANK as sbanktype
FROM UB_ORGINFO
WHERE -- BUSINESSCATEGORY !='1' AND
I_STATUS=1
AND S_DN IS NULL AND PBCBIGAREABANK=276
AND PBCBIGAREABANK IS not NULL) ;
end
---------------------
相关推荐
db2 create user sql
CREATE PROCEDURE DB2ADMIN.doc CREATE PROCEDURE DB2ADMIN.doc
在DB2中创建第一个触发器
db2 CREATE DATABASE mydb AUTOMATIC STORAGE YES ON '/home/db2inst1' DBPATH ON '/home/db2inst1' USING CODESET ISO-8859-2 TERRITORY SI COLLATE USING SYSTEM PAGESIZE 4096 db2 CREATE DATABASE qamis ...
db2 update dbm cfg using federated yes db2 catalog node (node节点登录) db2 catalog database (database数据库登录) db2 connect to db (连接到...db2 create nickname (创建连接到对方表的nickname)
db2命令集,非常好好的资料: Command Syntax CREATE DATABASE DB database-name AT NODE Create Database options * Create Database options: ON path drive ALIAS database-alias USING CODESET codeset ...
创建DB2数据库命令,包括创建表空间、缓存等完整命令
DB2数据库的创建 公司内部资源偷偷的拿出来偷偷的拿出来共享,以去掉相关公司声明!~全是为了大家相互学习,进步!~
db2驱动包 db2jcc4.jar db2jcc4.jar db2java.jar db2jcc_javax.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar db2policy.jar,压缩包无加密,可以放心下载,良心资源。
db2 list tables for schema [user] 复制一张表:db2 create table t1 like t2 显示表结构:db2 describe table tablename 查询表:db2 "select * from table tablename where ..." 执行SQL脚本:db2 -tvf scripts....
DB2DB2DB2DB2DB2DB2DB2DB2DB2
db2数据库安装包 db2数据库链接服务器驱动 db2数据库安装方法
DB2 11.5版本 jdbc db2jcc db2jcc4驱动。包含了所需的所有jar,新版jar命名为db2jcc4
This essay gives a demonstration of creating DB2 user function easily by DB Query Analyzer. And also the creating process of stored procedure has no difference with that of function What’s more, the ...
db2db2db2db2db2db2db2
Create, manage, and alter Db2 database objects Use the partitioning capabilities available within Db2 Enforce constraint checking with the SET INTEGRITY command Utilize the Db2 problem determination ...
db2驱动包 db2jcc4.jar db2jcc4.jar db2java.jar db2jcc_javax.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar db2policy.jar,压缩包无加密,可以放心下载,良心资源。
db2 数据库驱动jar包 db2java.jar,db2jcc.jar,db2_license_cu.jar
pom.xml中引入db2的配置信息 <groupId>com.ibm.db2</groupId> <artifactId>db2jcc4 <version>1.0.0 <scope>system 自己创建的存放db2jcc4.jar路径 <groupId>com.ibm.db2</groupId> ...
db2启动错误db2启动错误db2启动错误db2启动错误db2启动错误db2启动错误