Informix name qualification – PB Docs 2019

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

For example, these qualifications are all acceptable:

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

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

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2019

PB Docs 2019 Powerbuilder Documentation 2019

August 21, 2023

Was this article helpful?