set wk_proc_cnt = 0;
open cur_trsn;
trsn_loop:
loop
fetch next cur_trsn into c_tname,
c_prog_name,
c_sam_cnt,
c_load_cnt,
c_base_cond,
c_add_cond,
c_cycl_code;
set out_sqlstate = sqlstate;
if out_sqlstate = err_notfound
then leave trsn_loop
end if;
set wk_script = '';
set wk_script_select = '';
set wk_script_where = '';
select string(' select count(*) into c_sel_cnt',
' from ',rtrim(c_tname) )
into wk_script_select;
-- Input 조건절(기준년월일) Check
if c_base_cond <> '' then
select string(' where ',rtrim(c_base_cond),'= ',
char(39),rtrim(in_work_trgt_ymd),char(39) )
into wk_script_where;
else
select string(' where 1 = 1 ')
into wk_script_where;
end if;
-- 추가조건절 추가
if c_add_cond <> '' then
select string(wk_script_where,' and ',rtrim(c_add_cond))
into wk_script_where;
else
select string(wk_script_where, ' and 1 = 1 ' )
into wk_script_where;
end if;
-- Script 연결
select string(rtrim(wk_script_select),rtrim(wk_script_where))
into wk_script;
execute immediate wk_script ------> 이문장 괜찮은건가요?
사이베이스 12.7입니다. 특별한 error은 않나는데, 데이터 값을 로딩 시키지 못하네요..
execute immediate wk_script : 이부분이 의심이 가서요..
너무 초보적인 질문이라 죄송합니다.
|