Name resolution of SQL objects

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

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

With MySQL, an object name takes the following form:

[database.]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.