Execute SQL queries using ipisql

Use the ipisql utility to execute interactive SQL statements directed at the Data Archive server. Run the ipisql utility from the ..\PI\adm directory. The utility uses PI API to connect to Data Archive. When you run the utility, it connects to the default Data Archive server, writes version information to the screen, and then prompts for input:

D:\pi\adm\ipisql
Connecting to default PI System...Done
iPISQL Copyright (c) 1993-2000, OSI Software, Inc. All rights reserved.
PI API Version 1.3.4 PINet Protocol Version 00011101
Connected to PI 3.3 Build 361.43 on node "figaro"
PISQL>

To exit the ipisql utility, type: exit;

The error code from the processing of the last SQL statement is the return code of the ipisql utility. This allows error detection if the ipisql utility is used in a script.

For more information, see ipisql command-line options and Query submission.