-- 	各種リソースで、SYSTEM_ID='**' で、KBSAKU != '0' のレコードを見つけ、
	KBSAKU='0' に再セットします。

select count(*) from GEA03
	where SYSTEM_ID  = '**' 
	and KBSAKU       != '0'
	and FGJ          =  '1' ;

update GEA03 set KBSAKU='0'
	where SYSTEM_ID  = '**' 
	and KBSAKU       != '0'
	and FGJ          =  '1' ;



select count(*) from GEA08
	where SYSTEM_ID  = '**' 
	and KBSAKU       != '0'
	and FGJ          =  '1' ;


update GEA08 set KBSAKU='0'
	where SYSTEM_ID  = '**' 
	and KBSAKU       != '0'
	and FGJ          =  '1' ;


