information schema queries for Progress Open-Edge Databases

information_schema_queries_in_progress_open_edge_db.sql

    --table search
SELECT id '#'
      ,owner     AS schema_name
      ,c.tbl     AS table_name
      ,col       AS column_name
      ,nullflag  AS nullflag
FROM sysprogress.syscolumns_full AS c
WHERE 1=1
AND c.tbl LIKE '%%'
AND c.col LIKE '%order%'
AND c.tbl NOT LIKE 'PV_XL%'
ORDER BY table_name
        ,display_order

this article details connections and querying the number of connections