Using the Relational Data Framework › Searched, Cursor, and Table Management Operations

Searched, Cursor, and Table Management Operations

The CA OPS/MVS product supports SQL statements that define tables to store automation data and add, change, or reference this data. These statements support three types of operations:

• Searched Operations

  Searched operations update or delete only the contents of rows that meet some search criteria you specify. SQL statements that perform searched operations can process many rows of a table at once.

• Cursor Operations

  Cursor operations update or delete the contents of a range of rows you select specifically by pointing to them with a cursor. For example, you could invoke a set of statements to update rows A through E in a table.

  Since cursor operations process one row at a time, they are useful for automation applications written in the REXX or CLIST languages where processing only one row at a time is desired.

• Table Management Operations

  Table management operations manage your tables, including altering, creating, or deleting them.