Tune Database Queries in Editor

APIs to view tune Progress database queries. Database has to be connected to PASOE instance.

Go To Lab

• Click on Overview top menu option.
• To access actions on databases connected to PAS instances in selected environment click on Databases tab:

• Click on Go To Lab menu option.

Run Database queries in Editor

• Click on Editor tab to view database query design form:

Design freeform ABL query

• Output query results to file
• Comment query for historical data storage
• Define number of query subsequent runs

Run query

• Click on Run button to run query

View query results

• View each query details in a grid:

View query timing

• View query timing in a results grid:

View query XREF file

• Click on file with .xrf extension:

View query listing file

• Click on file with .lis extension:

View query records file

• Click on link in Records column:

View query ABL code

• Click on file with .p extension: