POI Command Processors › OPSQL Command—Invoke SQL Statements

OPSQL Command—Invoke SQL Statements

Use the OPSQL command to invoke SQL statements from a TSO terminal, a TSO CLIST, or a TSO/E REXX program.

OPSQL statement

Examples: OPSQL Statements

• To create a relational table named DAILY_SCHEDULE, use the following TSO CLIST:

  PROC 0
   CONTROL MSG CONLIST SYMLIST
       OPSQL   CREATE TABLE DAILY_SCHEDULE                 +
          (NAME         CHAR(8) NOT NULL PRIMARY KEY,      +
           EVENT        CHAR(4) NOT NULL,                  +
           TYPE         CHAR(1) UPPER CASE,                +
           STATUS       CHAR(1) UPPER CASE,                +
           SCHED_DATE   DATE,                              +
           SCHED_TIME   TIME,                              +
           REPEAT_TIME  TIME,                              +
           RUN_DATE     DATE,                              +
           RUN_TIME     TIME,                              +
           END_DATE     DATE,                              +
           END_TIME     TIME,                              +
           MAX_CC       CHAR(4),                           +
           PREREQ1      CHAR(20),                          +
           PRETYPE1     CHAR(1),                           +
           PREREQ2      CHAR(20),                          +
           PRETYPE2     CHAR(1),                           +
           PREREQ3      CHAR(20),                          +
           PRETYPE3     CHAR(1)) SUB(OPSF)
  WRITE &SQLCODE
  WRITE &SYSOUTLINE
  WRITE &LASTCC
  

• To change the current state, desired state, and mode values specified for a resource, invoke a CLIST or REXX program that contains the following clause:

  OPSQL UPDATE tablename SET columnname = 'state' WHERE NAME = 'name'