external_sql
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.
syslocks.sql
Select from syslocks table.
SQL file /infx/local/sql/external/syslocks.sql:
1 |
select * from syslocks; |
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
1 2 3 4 5 6 |
$ infx status list=ext_syslocks vars=dbsname+tabname+type sysmaster sysdatabases S sysmaster sysdatabases S sysmaster sysdatabases S sysmaster sysdatabases S sysmaster sysdatabases S |