Solution for NSC-KVP accounts having invalid remarks for discharged accounts in binder

Query to solve NSC/KVP accounts having invalid remarks for discharged accounts in binder discrepancy noticed in DPT V 7.3 .

Note : Kindly verify each and every account status manually in Gardfile before going to apply the below solution. The below query is created by admin is based account status of gardfile of NSC/KVP. The blog / author of this post is not responsible for data loss/ incorrect updation.

update dcl.nsc_binder
set remarks='DISCHARGED'
WHERE REMARKS='PURCHASED' and slno in (select slno from dcl.nsc_gardfile where remarks='DISCHARGED')

update dcl.nsc_binder

Also read :Tool for SB Account Sequence Number Correction by PoTools

set remarks='PURCHASED'
WHERE REMARKS='DISCHARGED' and slno in (select slno from dcl.nsc_gardfile where remarks='PURCHASED')

update dcl.kvp_binder
set remarks='DISCHARGED'

Also read :Tool for DPT Discrepancies Accounts having null name and address in comindex

WHERE REMARKS='PURCHASED' and slno in (select slno from dcl.kvp_gardfile where remarks='DISCHARGED')

update dcl.kvp_binder
set remarks='PURCHASED'
WHERE REMARKS='DISCHARGED' and slno in (select slno from dcl.kvp_gardfile where remarks='PURCHASED')

The above query may be executed by the System Admin with his/her Own risk. Best advise take Backup before going to apply the above query.

Dhrubajyoti Rudra. SA,Belgharia H.O. North Presidency Division