Execute your own systemaster SQL statement.

Use infx status to run a simple select statement on the sysmaster syslocks.

infx looks for external sql files in /infx/local/sql/external.

The files must be owner/group informix and have permissions 660.


Select from syslocks table.

SQL file /infx/local/sql/external/syslocks.sql:

Reference the results of the SQL via a list variable, named the same as the SQL file i.e. ext_syslocks.

Make sure you alias any expressions in the select, you need a column name for reference.

You can use a number select statements, as long as all but the last go into temp tables

To access the results of syslocks.sql