FIT
100
Advanced Data Management Commands
;
UPDATE PRODUCT
SET P_SALECODE = ‘2’
WHERE P_INDATE < 8/15/96;
;
;
;
UPDATE PRODUCT
SET P_SALECODE = ‘1’
WHERE P_INDATE >= ‘11/15/96’
AND P_INDATE < ‘12/1/96’;