PROC FedSQL or PROC DS2 might produce errors similar to the following when you assign multiple LIBNAME connections to a database that supports native catalogs:

Native catalogs are automatically included in the database connection and are not listed in the CATALOG= parameters. To circumvent the errors, you need to specify all additional native catalog entries in the connection string, and you need to rename any entries that produce errors.  

For example, the following Netezza server has two native catalogs named MODEL and SYSTEM. An error similar to the following occurs for each
duplicate catalog name found:

The example below shows how you can rename the two catalog names to circumvent the errors.  

To write the connection strings for all of the LIBNAMES currently assigned in the SAS^® session to the SAS log, add this option before the PROC DS2 or PROC FedSQL statement: 

The connection strings below illustrate how to rename the catalog names to circumvent the errors caused by duplicate names.

To prevent the connection strings from being written to the SAS log, add this option: 

Another workaround for the problem is to specify the schema (such as dbo and abc) in the table name as shown here:

Operating System and Release Information