[uniERPII] Locking 해제

USE UNIERP

GO

 

SELECT * FROM B_MAJOR WHERE MAJOR_CD = 'Z0010';
SELECT * FROM B_MINOR WHERE MAJOR_CD = 'Z0010';

SELECT * FROM Z_LOG_IN_HSTRY WHERE STATUS IN ('4') ORDER BY LOGIN_DT DESC;

 

-- UPDATE Z_LOG_IN_HSTRY SET

        STATUS = '5' WHERE STATUS = '4' AND USR_ID = 'UNIERP';