POI Command Processors › OPSQL Command Processor—Invoke SQL Statements

OPSQL Command Processor—Invoke SQL Statements

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

OPSQL has the following format:

OPSQL
{statement}

Note: The Using the Relational Data Framework chapter 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.

OPSQL Installation Requirements

OPSQL Utilization Environments

OPSQL Sample Coding Statements

OPSQL Return and Reason Codes