Informatica PostgreSQL Uncached Lookup

55 views Asked by At

I am using Informatica PowerCenter 10.4.1 with the DataDirect 7.1 PostgreSQL Wire Protocol driver to do an uncached lookup to a table in PostgreSQL 14 database. The uncached lookup is using bind parameters in a SQL override. This is the SQL override in the lookup (this is a simplified version of a more complex query I am using for testing):

select
CASE
WHEN ?i_PARM?::integer = 0
THEN 'param = 0'
WHEN ?i_PARM?::integer = 1
THEN 'param = 1'
WHEN ?i_PARM?::integer is null
THEN 'param = null'
END AS PARM_VALUE
FROM public.dual--

The lookup works fine. It produces the correct result and the session log does not have any errors. The problem is the DBAs are seeing errors in the database log files like this:

ERROR: syntax error at or near "i_PARM$2" at character 23

STATEMENT: select
   CASE
   WHEN $i_PARM$2::integer = 0
   THEN 'param = 0'
   WHEN $i_PARM$4::integer = 1
   THEN 'param = 1'
   WHEN $i_PARM$6::integer is null
   THEN 'param = null'
   END AS PARM_VALUE
   FROM public.dual--

Is there anything I can do to make the database log error message go away? It seem strange to me the database is logging it as an error, but Informatica does not and also produces the correct results.

0

There are 0 answers