Chat now with support
Chat with Support

SharePlex 9.0.2 - Preinstallation Checklist

How to specify case-sensitive names

If the owner (schema or database name) or name of an object is case-sensitive in the database, you must enclose the name within quotes in the SharePlex configuration file.

Note: This applies whether the database itself requires a case-sensitive name to be within quotes, such as Oracle, or whether the database accepts a name that is spelled out in its case-sensitive form without quotes, like SQL Server.

The correct way to specify a fully qualified object name, where both the owner (schema or database) and object components are case-sensitive, is as follows:

"HumanResources"."Employees"

The following is not correct, because both components are within one set of quotes:

"HumanResources.Employees"

If only one of the components is case-sensitive, enclose only that name within quotes, and specify the non-case-sensitive name in any case. For example, any of the following is correct:

HumanResources."Employees"

HUMANRESOURCES."Employees"

humanresources."Employees"

If a name is not enclosed within quotes in the configuration file, Post converts it to UPPER CASE in its DML operations on the target.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating