Using the Relational Data Framework › Storing Data in and Requesting Data From Relational Tables

Storing Data in and Requesting Data From Relational Tables

You store automation data in a relational table in one of two ways:

• By specifying all of the data on an SQL UPDATE or INSERT statement.

  The following sample rule clause invokes an UPDATE statement that:

  • Looks for a row in the SYSTEMS table where the NAME column contains the value CICS
  • Assigns the values UP and DOWN to the CURRENT_STATE and DESIRED_STATE columns in that row

    ADDRESS SQL
      "UPDATE SYSTEMS SET CURRENT_STATE = 'UP',",
        "DESIRED_STATE = 'DOWN' WHERE NAME = 'CICS'"
    

  In this series of SQL statements, a table named TESTTBL is created, and two rows are inserted into it:

  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''))')"
  

• By having the SQL statement specify host variables containing the values you want to set. For example, the following sample command tells the CA OPS/MVS product to place REXX variable values in the CURRENT_STATE and DESIRED_STATE columns:

  ADDRESS SQL
    "UPDATE SYSTEMS SET CURRENT_STATE= "CICS.CUR",",
      "DESIRED_STATE = "CICS2.DES" WHERE NAME = '”CICS"'"
  

More information:

Description of Host Variables