Precedence of dot notation

With HCL Informix®, a value that uses dot notation (as in proj.name) in an SQL statement in an SPL routine is interpreted as having one of three meanings, in the following order of precedence:
  1. variable.field
  2. column.field
  3. table.column

In other words, the expression proj.name is first evaluated as variable.field. If the routine does not find a variable proj, it evaluates the expression as column.field. If the routine does not find a column proj, it evaluates the expression as table.column. (If the names cannot be resolved as identifiers of objects in the database or of variables or fields that were declared in the SPL routine, then an error is returned.)