POI Command Processors › OPSQL Command Processor—Invoke SQL Statements

OPSQL Command Processor—Invoke SQL Statements

Use the OPSQL command processor to invoke SQL statements from a TSO terminal, a TSO CLIST, or a TSO/E REXX program. These SQL statements enable you to collect information about your system, organize it into tables containing rows and columns of related data, and retrieve data from those tables for use in OPS/REXX programs and AOF rules.

This command has the following format:

OPSQL
{statement}

Note: The chapter “Using the Relational Data Framework” in the User Guide describes each of the statements you can invoke through the OPSQL command processor and explains the syntax of each statement and how to use it.