Skip to Main Content

SQLEXEC Cannot Pass Out Parameter to Filter at Extract Parameter File

user13371969Feb 17 2011 — edited Mar 9 2011
Hi all,

I would like to do a record existing filtering by lookup demo.xx2 table at extract process in order to reduce the extract record to trail file. After setup, it is fail to pass out the ck_exist.existcnt from the SQL to filter. I tried to use procedure and the result is the result. Am I setup incorrect? Please advice

EXTRACT XTST01
USERID ogg@db, PASSWORD oracle
RMTHOST ogg, MGRPORT 7809
RMTTRAIL /ogg/dirdat/r1
TABLE demo.xx,
SQLEXEC (ID ck_exist, QUERY "select count(1) existcnt from demo.xx2 where id_no=:v_id_no", PARAMS (v_id_no = id_no)),
FILTER (@GETVAL (ck_exist.existcnt) > 0);


Thanks for your kindly help.

Jerry
Comments
Post Details
Added on Feb 17 2011
12 comments
342 views