- 论坛徽章:
- 0
|
db2 (続き)=> 什么意思
update d0003.dwh_t_enduser_inv set (pur_date,shop_name,shop_addr, disp_mtmod,disp_serial,pending_flag,expire_date,reg_route, warranty_date,reg_userid,reg_timestamp,upd_userid,upd_timestamp) = (select pur_date, shop_name,shop_addr,disp_mtmod,disp_serial,pending_flag, expire_date,reg_route,date(pur_date + 1 years),reg_userid, reg_timestamp,upd_userid,upd_timestamp from d0003.dwhwk_t_custprod where (customer_id = d0003.dwh_t_enduser_inv.customer_id) and ((mactype || model) = d0003.dwh_t_enduser_inv.part_num) and (serial = d0003.dwh_t_enduser_inv.serial)) where (customer_id, part_num, serial) in (select customer_id, mactype || model, serial from d0003.dwhwk_t_custprod)
这个SQL单独执行没有问题。但在程序中就停留在上面所说的层面上。
把这个SQL注释掉。程序在其他SQL地方同样也要停止。什么原因呢? |
|