Missing Keyword in SQL

Support/help with CloverETL implementation problems

Cloveretl76
Posts: 2
Joined: Tue May 16, 2017 3:41 pm

Missing Keyword in SQL

Postby Cloveretl76 » Thu Jun 01, 2017 5:10 pm

Hi,
I am pretty new to cloveretl. Trying to read and do some exercises and learn. I have a dbInputTable component where I have a SQL for that.

SELECT
$PARENT_SITE_KEY:= parent_site_key,
$SITE_KEY:= site_key,
$TOP_IND:= top_ind,
$BOTTOM_IND:= bottom_ind,
$RS_PRD_ID:= rs_prd_id
FROM (
SELECT
CASE p.prd_rel_type when 3 THEN p.parent_id else p.prd_id end as parent_site_key,
p.prd_id AS site_key,
CASE p.prd_rel_type WHEN 3 THEN 0 ELSE 1 END as top_ind,
CASE p.prd_rel_type WHEN 2 THEN 0 ELSE 1 END as bottom_ind,
p.prd_id AS rs_prd_id
FROM
${prm_SRC_SCHEMA}.p_prd p
LEFT JOIN
${prm_TGT_DB}.d_site s ON s.rs_prd_id = CASE p.prd_rel_type when 3 THEN p.parent_id else p.prd_id end
LEFT JOIN
${prm_SRC_SCHEMA}.p_prd p
LEFT JOIN
${prm_TGT_DB}.d_site s on s.rs_prd_id = p.prd_id

)


When I validate this, I am getting missing keyword error and I dont have the credentials to the db. So I am not able to connect to the db from TOAD or pl/sql and execute this SQL.
So pls help me in finding out what I am missing.

Thanks,

Cloveretl76
Posts: 2
Joined: Tue May 16, 2017 3:41 pm

Re: Missing Keyword in SQL

Postby Cloveretl76 » Fri Jun 02, 2017 2:26 pm

please discard. I got it totally wrong. They are from two sources.