You store automation data in a relational table in one of two ways:
The following sample rule clause invokes an UPDATE statement that:
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''))')"
ADDRESS SQL "UPDATE SYSTEMS SET CURRENT_STATE= "CICS.CUR",", "DESIRED_STATE = "CICS2.DES" WHERE NAME = '”CICS"'"
Copyright © 2014 CA.
All rights reserved.
|
|