Hello
this first REPLACE_QUERY is bad and ora2pg don't use it
REPLACE_QUERY TSTPCSA[
SELECT
e.employee_id,
e.first_name AS prenom,
e.last_name,
CASE
WHEN e.status = 'A' THEN 'ACTIVE'
WHEN e.status = 'I' THEN 'INACTIVE'
ELSE 'UNKNOWN'
END AS status,
e.salary
FROM SCGP.TSTPCSA e
]
But this REPLACE_QUERY is good
REPLACE_QUERY TSTPCSA[SELECT e.employee_id,e.first_name AS prenom,e.last_name,CASE WHEN e.status = 'A' THEN 'ACTIVE' WHEN e.status = 'I' THEN 'INACTIVE' ELSE 'UNKNOWN' END AS status, e.salary FROM SCGP.TSTPCSA e]
This second is written on same line, there is no CRLF in conf file
Regards
Hello
this first REPLACE_QUERY is bad and ora2pg don't use it
REPLACE_QUERY TSTPCSA[
SELECT
e.employee_id,
e.first_name AS prenom,
e.last_name,
CASE
WHEN e.status = 'A' THEN 'ACTIVE'
WHEN e.status = 'I' THEN 'INACTIVE'
ELSE 'UNKNOWN'
END AS status,
e.salary
FROM SCGP.TSTPCSA e
]
But this REPLACE_QUERY is good
REPLACE_QUERY TSTPCSA[SELECT e.employee_id,e.first_name AS prenom,e.last_name,CASE WHEN e.status = 'A' THEN 'ACTIVE' WHEN e.status = 'I' THEN 'INACTIVE' ELSE 'UNKNOWN' END AS status, e.salary FROM SCGP.TSTPCSA e]
This second is written on same line, there is no CRLF in conf file
Regards