Informix system table

--field and field type codes in a table
SELECT C.colname, C.coltype,t.owner from syscolumns C, systables t WHERE c.tabid = t.tabid and t.tabname = ' Dm_plc_policy '

--View Database temp table space usage
Select Pagesize,chksize,nfree from Sysmaster:syschunks where Dbsnum in (select Dbsnum from sysmaster:sysdbspaces where Nam E like ' tmp% ')

---to view the execution time of a stored procedure
Select Task_code,fn_dev_datetime (task_lendtime,task_lstarttime,3) as Task_exetime from Task_def where task_valid= ' 1 ' ORDER BY 2 Desc

---view table size
Select Trim (t1.tabname) tabname, trunc (SUM (t2.pe_size * 16384/(1024x768)), 2) Total_size from Sysmaster:systa Bnames T1, Sysmaster:sysptnext T2, Systables t
where T1.partnum = t2.pe_partnum and T1.tabname = T.tabname and t.tabname= ' Dm_plc_policy ' GROUP by 1;

Informix system table