Informix name qualification

Since PowerBuilder does not inspect all SQL statement syntax, you can qualify Informix catalog entities as necessary.

For example, these qualifications are all acceptable:

  • emp_name

  • employee.emp_name

  • Informix.employee.emp_name

Functions

You can use any function that Informix supports (such as aggregate or mathematical functions) in SQL statements.

This example illustrates how to call the Informix function HEX in a SELECT statement:

SELECT HEX(emp_num) INTO :emp_name_var FROM employee;DBMS=ODB