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
