Run sample SQL queries

PI OLEDB Enterprise includes one sample SQL query for each table in the catalog for PI AF server connections. Use these queries to explore PI SQL Commander Lite functionality, or edit and save these queries to use as a custom query.

Procedure

1. In the Object Explorer pane in the Catalogs folder, right-click either a table or a view in a database folder, and click Execute Predefined Query.

   

   Note: You can edit a sample query and save it as a customized query. For information about two additional collections of sample queries that you can load onto your system using PI SQL Commander Lite, see PI SQL Commander Lite Help

2. View the query in the Query pane and its results in the Results pane.