Question


Attunity Connect inserts the word "public". In Microsoft query it can not be viewed via the GUI interface (note:can be if the word "public" is inserted)

Is there a way of stopping PUBLIC being inserted in the SQL?

e.g

SELECT CMAST.CM_CUST_NO, CMAST.CM_CUST_NAME FROM SPL:public.CMAST CMAST



Answer

The public schema was added for ODBC applications that don't support null schemas. This is also became the default.


There is a temp feature that can disable this in case you are working in single tdp mode

Set the tempFeature
id='dontAddDefaultOwner' value='true' in the binding definition.