Run sample SQL queries

PI SQL Client ODBC 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.

1. In the Object Explorer pane, expand the schema under ODBC Data Sources > PI SQL Client.

   

2. In the Catalogs folder, right-click either a table or a view, 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 the PI SQL Commander Lite Help.

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