db2数据库操作项.docVIP

db2数据库操作项 1， 建表CREATE DATABASE database-name [IN dbspace-name] [WITH LOG] 2， 删库 DROP DATABASE database-name 3， 格式： DATABASE database-name 4，说明： 选择可访问的库作为当前库。 5，关闭库： CLOSE DATABASE 6，建表格式： CREATE [TEMP] TABLE table-name ( column-name datatype [NOT NULL],…) 7，删除表格式： DROP TABLE table-name 8，SELECT [DISTINCT] select-list FROM tablename [,…] select-list表的选项 tablename表名 SELECT fname, lname FROM customer WHERE state CA ORDER BY lname; SELECT fname, lname, age FROM customer WHERE age BETWEEN 20 and 30; SELECT max(age), min(age) FROM customer 9.删除列表项格式： DELETE FROM table-name [WHERE condition] 10，插入列表入操作 格式： INSERT INTO table-name [(column-list)] {VALUES (value-list) | SELECT-statement} 11，修改列表 UPDATE table-name SET {column-name = expression [,...]| {(col-list) | *} = (expr-list)} [WHERE condition] 修改还没有遇到 13， EXEC SQL DECLARE GLOBAL TEMPORARY TABLE tmplstb1 LIKE jkdzt NOT LOGGED; /*---------- 装载数据前准备 ----------*/ EXEC SQL DELETE FROM jkdzt WHERE 1=1; if( (SQLOK!=SQLCODE) (SQLNOTFOUND!=SQLCODE) ) { DISPLAY_INT(\n 装载数据前准备 error0 ! SQLCODE=,SQLCODE); goto err; } EXEC SQL DELETE FROM jkdzd WHERE trdt=:intrdt OR trdt:tpcldt;// ????? if( (SQLOK!=SQLCODE) (SQLNOTFOUND!=SQLCODE) ) { DISPLAY_INT(\n 装载数据前准备 error1 ! SQLCODE=,SQLCODE); goto err; } EXEC SQL UPDATE jkdzd SET ertp=0//更新数据 WHERE trdt=:yesterday AND pmtx=T; if( (SQLOK!=SQLCODE) (SQLNOTFOUND!=SQLCODE) ) { DISPLAY_INT(\n 装载数据前准备 error2 ! SQLCODE=,SQLCODE); goto err; } EXEC SQL DELETE FROM jkdzp WHERE trdt=:intrdt; if( (SQLOK!=SQLCODE) (SQLNOTFOUND!=SQLCODE) ) { DISPLAY_INT(\n 装载数据前准备 error3 ! SQLCODE=,SQLCODE); goto err; } /*---------- 创建临时表: 金卡对帐冲正记录临时表 ----------*/ EXEC SQL DECLARE GLOBAL TEMPORARY TABLE tmplstb1 LIKE jkdzt NOT LOGGED; if( SQLOK != SQLCODE ) { DISPLAY_INT(\n 创建临时表出错 ! SQLCODE=