You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
Activity
darold commentedon Sep 27, 2026
It is not possible to set any configuration setting values on multilines, you must use single line.