This section describes the Process Module statements that are used to access Oracle tables. The RELATE statement declares the Oracle tables that you are going to access. The Open SQL Process Module statements retrieve, add, delete, and update rows. ACCENT R allows up to 8192 characters per SQL statement. Thus complex coding can be passed to the Oracle server.
The USE ORACLE SERVER AS user_name command of ICL declares the current Oracle Server file name to be used for subsequent data access. This schema will be referenced by each Process Module (PM) as the location of the desired Oracle table.
The RELATE statement in the Control Section of a Process Module specifies the name of a table, the designator used to refer to the table in subsequent statements, and the type of operations that the Process Module performs on the table.
In an ACCENT R Process Module, you can define an SQL transaction that manipulates Oracle data by marking the end of the transaction with the statement SQL COMMIT WORK. All data manipulation can be rolled back with the SQL ROLLBACK WORK statement.
The SQL DELETE statement removes one or more rows of data from an Oracle table.
The SQL INSERT statement appends one or more rows of data to an Oracle table.
The SQL SELECT statement identifies a group of qualifying rows that will be retrieved one at a time by a subsequent SQL FETCH statement. The SQL FETCH statement must be used with an SQL SELECT statement in a Process Module.
The SQL UPDATE statement changes data in existing rows by modifying existing data.