SQLEXEC Cannot Pass Out Parameter to Filter at Extract Parameter File
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
USERID ogg@db, PASSWORD oracle
RMTHOST ogg, MGRPORT 7809
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.