db2数据库操作项

AND tzsbno=:tz6502I.sbno
AND tztrdt=:tz6502I.trdd
AND tzjydm='6500'
17. v_init_tzinf(&stTzinf);
EXEC SQL SELECT * INTO :stTzinf :idts FROM tzinf///////////////////查询
WHERE tzbrno=:tz6502I.brno
if( (SQLOK!=SQLCODE) && (SQLNOTFOUND!=SQLCODE) ) {
DISPLAY_INT("\n 装载数据前准备 error0 ! SQLCODE=",SQLCODE);
goto err;
}
EXEC SQL DELETE FROM jkdzd
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;
18 /*----------插入调帐登记表------------*/ ///////////////////插入
EXEC SQL INSERT INTO tzinf VALUES(:stTzinf);
AND rtirtp='51'
AND rtirkd='0'
AND rtefdt<=:ca2967I.cldt
ORDER BY rtefdt DESC
FOR READ ONLY WITH UR;
修改还没有遇到
13， EXEC SQL DECLARE GLOBAL TEMPORARY TABLE tmplstb1 LIKE jkdzt NOT LOGGED;
/*---------- 装载数据前准备 ----------*/
EXEC SQL DELETE FROM jkdzt WHERE 1=1;
SELECT max(age), min(age) FROM customer
9.删除列表项格式： DELETE FROM table-name [WHERE condition]
10，插入列表入操作
格式： INSERT INTO table-name [(column-list)]
19。 vi操作符 mkdir新建文件夹
20.显示当前进程 ps
21。移动文件mv 文件名 路径
22tar cvf myfiles.tar.gz files/ //打包，压缩文件
c表示建立归档
z表示归档进行压缩
f用于指定建立的归档文件名
AND rtstcd=:STCDA;
16, EXEC SQL DECLARE pmrta_txcur CURSOR FOR//////////////////声明游标
SELECT * FROM pmrta
WHERE rtcyno='01'
tar xvf myfiles.tar.gz -C restore/ 解压缩文件
x表示回复归档
23.
EXEC CICS ADDRESS EIB(dfheiptr) RESP(respCode);
AND tzjyls=:tz6502I.tzsq
AND tzstcd=:STCDA;
之间的区别
EXEC SQL DECLARE cur CURSOR for//这是申请游标
SELECT * FROM ddmsa
WHERE msstcd='C'
FETCH FIRST 10 ROWS ONLY;
WHERE cbtrdt=:intrdt
AND cbtrcd IN ('4321','4322','4342') /*4342中部分冲正插bkcba的,全部冲不插*/
AND cbwkzz='' /* 去掉外卡 */
AND cbstcd=:STCDA
if (SQLOK!=SQLCODE) {
DISPLAY_INT("\n 插入调帐登记表出错! CODE=",SQLCODE);
error.ID=ERROR_ERR;
sprintf(error.MSG,"插入调帐帐登记表出错!");
goto end;
}
EXEC SQL OPEN pmrta_txcur;
if( SQLOK != SQLCODE ) {
DISPLAY_INT("\n open pmrta_txcur error ! SQLCODE=",SQLCODE);
goto end;
WHERE trdt=:intrdt
OR trdt<:tpcldt;// ?????
if( (SQLOK!=SQLCODE) && (SQLNOTFOUND!=SQLCODE) ) {
DISPLAY_INT("\n 装载数据前准备 error1 ! SQLCODE=",SQLCODE);
1， 建表CREATE DATABASE database-name [IN dbspace-name] [WITH LOG]
2， 删库 DROP DATABASE database-name
3， 格式： DATABASE database-name
4，说明： 选择可访问的库作为当前库。
(SELECT MAX(rtefdt),rtirtp,rtirkd,rtperd FROM pmrta WHERE rtcyno='01'
AND rtirtp=:ca2831I.irtp
AND rtirkd='0'
group by rtirtp,rtirkd,rtperd)
goto err;
}
EXEC SQL UPDATE jkdzd SET ertp='0'//更新数据
WHERE trdt=:yesterday AND pmtx='T';
if( (SQLOK!=SQLCODE) && (SQLNOTFOUND!=SQLCODE) ) {
{VALUES (value-list) | SELECT-statement}
11，修改列表 UPDATE table-name
SET {column-name = expression [,...]| {(col-list) | *} = (expr-list)}
[WHERE condition]
DISPLAY_INT("\n 装载数据前准备 error3 ! SQLCODE=",SQLCODE);
goto err;
}
/*---------- 创建临时表: 金卡对帐冲正记录临时表 ----------*/
EXEC SQL DECLARE GLOBAL TEMPORARY TABLE tmplstb1 LIKE jkdzt NOT LOGGED;
DISPLAY_INT("\n 创建临时表出错 ! SQLCODE=",SQLCODE);
goECLARE bkcba_cursor CURSOR FOR
SELECT * FROM bkcba
}
15,
SELECT * FROM pmrta
WHERE rtcyno='01'
AND (rtefdt,rtirtp,rtirkd,rtperd) in////////////////////////////////在哪些字段
EXEC SQL DECLARE GLOBAL TEMPORARY TABLE tmplstb2 LIKE jkdzt NOT LOGGED;
if( SQLOK != SQLCODE ) {
DISPLAY_INT("\n 创建临时表出错 ! SQLCODE=",SQLCODE);
FOR READ ONLY;
EXEC SQL OPEN bkcba_cursor;
if(SQLOK!=SQLCODE) {
DISPLAY_INT("\n open cursor bkcba_cursor error!",SQLCODE);
goto err;
if( SQLOK != SQLCODE ) {
DISPLAY_INT("\n 创建临时表出错 ! SQLCODE=",SQLCODE);
goto err;
}
/*---------- 创建临时表: 主机对帐撤消记录临时表 ----------*/
goto err;
}
/*---------- 创建临时表: 对帐差错临时表 ----------*/