declare variable first_tm integer;
declare variable tm_rec integer;
declare variable tm_cur integer;
declare variable tm_old integer;
declare variable v1 float;
declare variable v2 float;
declare variable v float;
declare variable old_value float;
declare variable rec_time integer;
declare variable rec_tid integer;
declare variable rec_value float;
declare variable logstatus integer;
if ((LogStatus = 0) or (LogStatus =1)) then
begin
while ((tm_Old < tm_Cur) and (tm_Old < to_tm)) do
begin
trd_TIME = tm_Old;
suspend;
tm_Old = tm_Old + intv;
end
tm_Old = tm_Cur;
end
FireBird Procedure를 MariaDB Procedure로 변경중입니다.
중간에 Suspend 명령어가 하는일과 MariaDB로 변경시 어떤 명령어로 대체하는게 좋을까요?