imp_yunwei/imp更改合同类型的sql...

SELECT * FROM SGGMIIP."purchaseContract" pc WHERE pc."pono" ='POS52050250017' AND IFNULL(pc."del_flag",0) <> 1;
SELECT * FROM SGGMIIP."purchaseOrder" po WHERE po."pono" ='POS52050250017' AND IFNULL(po."del_flag",0) <> 1;
SELECT * FROM SGGMIIP."contrRegLedger" crl WHERE crl."contrNo" ='POS52050250017' AND ifnull(crl."del_flag",0) <> 1;
SELECT * FROM SGGMIIP."purMultiSettle" pms WHERE pms."pono" ='POS52050250017' AND ifnull(pms."del_flag",0) <> 1;

UPDATE SGGMIIP."purchaseContract" pc SET "bizType" ='进口采购' 
WHERE "pono" ='POS52050250017' AND IFNULL(pc."del_flag",0) <> 1;
UPDATE SGGMIIP."purchaseOrder" po SET "bizType" ='进口采购' 
WHERE "pono" ='POS52050250017' AND IFNULL(po."del_flag",0) <> 1;
UPDATE SGGMIIP."contrRegLedger" crl SET "bizType" ='进口采购' 
WHERE "contrNo" ='POS52050250017' AND IFNULL(crl."del_flag",0) <> 1;
UPDATE SGGMIIP."purMultiSettle" pms SET "bizType" ='进口采购' 
WHERE "pono" ='POS52050250017' AND IFNULL(pms."del_flag",0) <> 1;