tháng 1 18, 2024
---------------- Tim but toan mo tk
-Script content:
SELECT * FROM INTELLECT.GR020MB WHERE CIF_NO ='0128983876' AND STATUS = 'c'
SELECT * FROM INTELLECT.GR020wB WHERE AC_NO = '0000000103407285' and status = 'U' --and auth_flg = 'U'
SELECT * FROM INTELLECT.GR016wB where cust_rel_ac = '0000000103407285' and status = 'U'
SELECT auth_flg, a. * FROM intellect.ca010wb a where ac_no = '0000000103407285' and auth_flg = 'U'
SELECT * FROM intellect.aa010mb WHERE AC_NO ='0000000103407285'
SELECT * FROM INTELLECT.CA015WB where ac_no = '0000000103407285' and status = 'U'
SELECT * FROM intellect.AO030mb where ac_no = '0000000103407285'
select * from intellect.wf110tb where ref_no ='0000000103407285'
select * from intellect.wf130tb where ref_no ='0000000103407285'
--UPDATE
-Script content:
delete INTELLECT.GR020MB WHERE AC_NO = '0000000103407285' AND STATUS = 'c'$$
delete INTELLECT.GR020wB WHERE AC_NO = '0000000103407285' and status = 'U' $$
delete INTELLECT.GR016wB where cust_rel_ac = '0000000103407285' and status = 'U'$$
delete intellect.ca010wb where ac_no = '0000000103407285' and auth_flg = 'U' $$
delete intellect.aa010mb WHERE AC_NO ='0000000103407285'$$
delete INTELLECT.CA015WB where ac_no = '0000000103407285' and status = 'U'$$
delete intellect.AO030mb where ac_no = '0000000103407285' $$
delete intellect.wf110tb where ref_no ='0000000103407285'$$
DELETE intellect.wf130tb where ref_no ='0000000103407285'
