Phil
Phil
Programming language:Whatever
2021-07-26 13:18:18
0
Q:

is -10 earnigns higher than -20 earnings

Gin
Gin
Code: Whatever
2021-08-26 17:37:37 
// Queries used for updates to the AUDIT tables
SELECT * FROM GUDA.AUDIT WHERE CHANGED_FIELD = 'STATUS';
SELECT * FROM GUDADEV.AUDIT WHERE CHANGED_FIELD = 'STATUS';
SELECT * FROM GUDATEST.AUDIT WHERE CHANGED_FIELD = 'STATUS';


SELECT * FROM GUDA.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';
SELECT * FROM GUDADEV.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';
SELECT * FROM GUDATEST.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';


UPDATE GUDA.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';
UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';
UPDATE GUDATEST.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';


UPDATE GUDA.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDATEST.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';

UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD IN ('STATUS','DEPT_STATUS');
0

Related

New to Communities?

Join the community