Using System State Manager › Modify Table Data with the STATESET Program

Modify Table Data with the STATESET Program

After you create resource tables for the use of SSM, you can change the current state, desired state, and MODE values specified for a resource in three ways:

• By invoking an SQL UPDATE statement from a rule or OPS/REXX program. The rule or OPS/REXX program should contain a clause like the following:

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

• By invoking an SQL UPDATE statement from a CLIST or TSO/E REXX program. This CLIST or REXX program should contain a clause like the following:

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

• By using the STATESET program