Query submission

To send a query to Data Archive, type SQL statements at the prompt and terminate with a semicolon (;). The query can span multiple lines. The prompt for subsequent lines looks like:

_PISQL>

You can use as many lines as you like.

You can also process queries stored in a text file using the file command:

PISQL>file myquery.txt;

A query in a file need not be terminated with a semicolon; the query is processed when the end of the file is reached.

A query file may contain more than one query. If this is the case, a semi-colon must be used to separate the queries.

Query files may contain the file command.