The problem is resolved.THE PROBLEM: Found this SAP setting in ds_odbc.ini but NOT in .odbc.ini file.NoteRebrandedLib = TRUE is required when using the SAP rebranded Data Direct driverTHE SOLUTION:NoteRebrandedLib = FALSE This is a postgres odbc dri...
I'm seeing the same issue with Postgres as the target....A simple select via the sql() function in a loop causes a unique connection the backend postgres database per each sql() call, and it keeps it open (does not disconnect until the JOB completes)...