select T.FLAG_VALUE into oi_flag from LBI_SYS_VDF.t_s_flag t where t.flag_code = 'DEBUG';
if oi_flag = '1' then
insert into LBI_SYS_VDF.t_s_sys_log
(
log_month, -- add month partition
task_id, -- task id
task_name, -- program name
table_name, -- target table name
task_sign, -- task sign,task start date
start_time, -- task start time
end_time, -- task end time or error time
task_status, -- task status
task_log, -- task log description
task_pos, -- task position
row_count -- count of the data record
)
if oi_flag = '1' then
insert into LBI_SYS_VDF.t_s_sys_log
(
log_month, -- add month partition
task_id, -- task id
task_name, -- program name
table_name, -- target table name
task_sign, -- task sign,task start date
start_time, -- task start time
end_time, -- task end time or error time
task_status, -- task status
task_log, -- task log description
task_pos, -- task position
row_count -- count of the data record
)