Using the Relational Data Framework › Operations Performed With the CA OPS/MVS SQL

Operations Performed With the CA OPS/MVS SQL

Using the CA OPS/MVS version of SQL, you can perform tasks that create, modify, access, or delete relational tables. The CA OPS/MVS SQL allows you to perform three types of operations:

• Searched operations retrieve, update, or delete data in rows that meet some search criteria you specify. Through searched operations, the CA OPS/MVS product can process many rows of a table all at once.
• Cursor operations retrieve, update, or delete data in a range of rows that you select, one row at a time. To select rows, you point to them with a cursor.
• Table management operations manage your tables, including altering, creating, or deleting them.

More information:

Clauses Used in Searched Operations

Cursor Operations

Table Management Operations