UPDATE ASICM SET SGROUP='' WHERE SGROUP IS NULL
UPDATE ASICM SET SCATEG='' WHERE SCATEG IS NULL
UPDATE ASICM SET CLASS='' WHERE CLASS IS NULL
UPDATE ASICM SET LOCATION='' WHERE LOCATION IS NULL
UPDATE ASICM SET STORE_NO='' WHERE STORE_NO IS NULL
UPDATE ASICM SET PERISHABLE='' WHERE PERISHABLE IS NULL
UPDATE ASICM SET SUPPLIER='' WHERE SUPPLIER IS NULL
UPDATE ASICM SET DAC='' WHERE DAC IS NULL
UPDATE ASICM SET DEPTNO='' WHERE DEPTNO IS NULL
UPDATE ASICM SET UPD='' WHERE UPD IS NULL
UPDATE ASICM SET BLKITEM='' WHERE BLKITEM IS NULL
UPDATE ASICM SET MODELNO1='' WHERE MODELNO1 IS NULL
UPDATE ASICM SET MODELNO2='' WHERE MODELNO2 IS NULL
UPDATE ASICM SET MODELNO3='' WHERE MODELNO3 IS NULL
UPDATE ASICM SET DESC1='' WHERE DESC1 IS NULL
UPDATE ASICM SET DESC2='' WHERE DESC2 IS NULL
UPDATE ASICM SET ACTIVE='A' WHERE ACTIVE IS NULL
UPDATE ASICM SET VOLACTIVE='' WHERE VOLACTIVE IS NULL