Host Commands › ADDRESS SQL—Create and Maintain SQL Tables

ADDRESS SQL—Create and Maintain SQL Tables

Use the ADDRESS SQL host environment to create and maintain SQL tables in the CA OPS/MVS RDF component. You invoke an SQL statement from an AOF rule or an OPS/REXX program.

ADDRESS SQL
 sqlstatement

SQL Statements:

ALTER TABLE
CLOSE
CREATE TABLE.
DECLARE CURSOR
DELETE FROM
DROP TABLE
FETCH 
INSERT
OPEN
SELECT
UPDATE

Examples: ADDRESS SQL create and update table statements

• To create a table named TESTTBL and insert two rows into it, use the following series of SQL statements:

  ADDRESS SQL
   "CREATE TABLE TESTTBL (ACTION_NAME CHAR(17) NOT NULL PRIMARY KEY,",
     "ACTION_TYPE CHAR(8) NOT NULL PRIMARY KEY, ACTION_TEXT CHAR(200))"
  
  ADDRESS SQL
    "INSERT INTO TESTTBL (ACTION_NAME, ACTION_TYPE, ACTION_TEXT)",
      "VALUES ('UNKNOWN', 'TEST1', 'TSOCMD(OPSWTO TEXT(''UNKNOWN FIRED''))')"
  
  ADDRESS SQL
    "INSERT INTO TESTTBL (ACTION_NAME, ACTION_TYPE, ACTION_TEXT)",
      "VALUES ('DOWN_UP', 'TEST1', 'TSOCMD(OPSWTO TEXT(''DOWN_UP FIRED''))')"
  

• To change the current state, desired state, and mode values specified for a resource, invoke the following SQL UPDATE statement from a rule or OPS/REXX program:

  ADDRESS SQL 
     "UPDATE tablename SET columnname = 'state' WHERE NAME = 'name'"