測(cè)試中，有時(shí)候需要臨時(shí)修改/刪除表中的數(shù)據(jù)，又不能影響用戶的測(cè)試。這時(shí)，便需要使用PATCH來改變數(shù)據(jù)。
具體的方法是，在大機(jī)環(huán)境下，編寫shell腳本來執(zhí)行db2命令。
舉例：
#! /usr/bin/ksh
#
#
#
db2 connect to 表名 user <userid> using <password>
db2 set current schema <schema名>
#導(dǎo)出表中數(shù)據(jù)，備份檢證用
db2 "export to T37A00MG_01BEFORE.csv of del messages export.log select * from T37A00MG"
db2 "export to T37A00SF_01BEFORE.csv of del messages export.log select * from T37A00SF"
#查詢
db2 "select KA4ZN,TE0WA,COUNT(*) from T37A00MG group by KA4ZN,TE0WA"
db2 "select KA4ZN,TE0WA,COUNT(*) from T37A00SF group by KA4ZN,TE0WA"
#更新數(shù)據(jù)
db2 "update T37A00MG set TE0WA='SYSTEM' where TE0WA<> 'SYSTEM'"
db2 "update T37A00SF set TE0WA='SYSTEM' where TE0WA<> 'SYSTEM'"
#查詢確認(rèn)
db2 "select KA4ZN,TE0WA,COUNT(*) from T37A00MG group by KA4ZN,TE0WA"
db2 "select KA4ZN,TE0WA,COUNT(*) from T37A00SF group by KA4ZN,TE0WA"
#導(dǎo)出表中數(shù)據(jù)，備份檢證用
db2 "export to T37A00MG_02AFTER.csv of del messages export.log select * from T37A00MG"
db2 "export to T37A00SF_02AFTER.csv of del messages export.log select * from T37A00SF"