Name resolution of SQL objects

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

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

With Netezza®, an object name takes the following form:

[database.[schema].]identifier

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.