Name resolution of SQL objects

Informix® uses the following form to identify an SQL object:

[database[@dbservername]:][{owner|"owner"}.]identifier

With Sybase ASE, an object name takes the following form:

[{database|[database]}.[{owner|[owner]}.]]{identifier|[identifier]}

Informix database object names are not case sensitive in non-ANSI databases.

Sybase ASE database objects names are case sensitive by default.

Solution

As a general rule, to write portable SQL, you should only use simple database object names without any database, server or owner qualifier and without quoted identifiers.

Always create and use tables and columns names in lower case.