用shell处理db2数据库的程序(国外英文资料).docVIP

用shell处理db2数据库的程序(国外英文资料) Use the shell to process the db2 database program, extract db2 data from the shell, and process it. # SQL hereinafter defined SQL = SELECT AAA, BBB, CCC FROM MYTBL1 # execute SQL ` SDATA = ` db2 $SQL # return value judgment If [$? -ne 0] then # shows the error message returned by db2 Echo $SDATA. The exit 1 fi The # is processing the obtained data. Echo $SDATA | sed -e ^ $4 / /! D; / ^ $/ d | While the read AAA BBB CCC The do Echo AAA IS $AAA, BBB IS $BBB, CCC IS $CCC The done # get the number of data Echo $SDATA | sed - n - e / ^ ${1, 3 d; N; S / * \ [^ 0-9] ([0-9] * \] / \ [^ 0-9] * 1 /; P; | read CNT The count of selected data is $CNT. The exit 0 Update db2 data and update the results SQL = UPDATE MYTBL1 SET AAA = 2005, BBB = 05, CCC = 12 # execute SQL SDATA = ` db2 - a $ SQL ` # get SQLCODE Echo $SDATA | sed - n - e s / ^. * sqlcode: \ [[-- 0-9] [0-9] * \). * / 1 / p \ | read sqlcode Echo Sqlcode is $Sqlcode. # get SQLSTATE Echo $SDATA | sed - n - e s / ^. * sqlstate: \ [[-- 0-9] [0-9] * \). * / 1 / p \ | read sqlstate Echo Sqlstate is $Sqlstate. # to update the number (that is, the third value of sqlerrd) Echo $SDATA | sed - n - e / sqlerrd/s / ^. * (3) \ [[-- 0-9] [0-9] * \). * / 1 / p \ | read UPDCNT Echo Updated datas count is $UPDCNT. # get the fifth value of sqlerrd Echo $SDATA | sed - n-e / sqlerrd / {n; S / ^. * (5) \ [-- 0-9] [0-9] * \). * / 1 / \; P; } | read SQLERRD5 Echo Sqlerrd (5) is $SQLERRD5. ,?????? The first one: # SQL text definition SQL = SELECT AAA, BBB, CCC FROM MYTBL1 # execute SQL ` SDATA = ` db2 $SQL # return value judgment If [$? -ne 0] then # shows the error message returned by db2 Echo $SDATA. The exit 1 fi The # is processing the obtained data. Echo $SDATA | sed -e 4, / ^ $/! D; / ^ $/ d | While the read AAA BBB CCC The do Echo AAA IS $AAA, BBB IS $BBB, CCC IS $CCC The done # get the number of data Echo $SDATA | sed - n - e / ^ ${1, 3 d; N; S / * \ [^ 0-9] ([0-9] * \] / \ [^ 0-9] * 1 /; P; | read CNT The