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

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