DBA追溯表维护说明

$dbhost="192.168.1.233";
$table="r_sn_detail_h";

require_once("movedb.phar");	
require_once("phar://movedb.phar/movedb.php");

echo version();
$tick=getTickCount();
$sns=get_sn(100000,"","");
if(is_array($sns)){
	if($sns){
		foreach($sns as $sn=>){
			echo move_sn($sn);
			echo "\r\n";
		}
	}else{
		echo "no sn found!\r\n";
	}
}else{
	echo $sns;
}
$tick=getTickCount()-$tick;
echo "[ Execute Time: {$tick} ]\r\n";

select vr_value from sfc.c_parameter_ini
        where prg_name='QUEYR6'
        and vr_name='DETAIL_TABLE'
        order by vr_desc

call sfc.MOVE_DATA_R117('20211101');
call sfc.MOVE_DATA_R117('20211102');
call sfc.MOVE_DATA_R117('20211103');
call sfc.MOVE_DATA_R117('20211104');
call sfc.MOVE_DATA_R117('20211105');
call sfc.MOVE_DATA_R117('20211106');