In the Interactive SQL Service Facility, you can use the following SQL Data Manipulation Language (DML) statements to insert, update, or delete data in SQL tables in the production database. See How to Submit SQL Statements.
Deletes rows that meet a specified condition from a table or view. Deleting a row from a view deletes the row from the table on which the view is based. See DELETE for the statement syntax and more information.
Inserts a row into a table or view. Inserting a row into a view inserts the row into the table on which the view is based. See INSERT for the statement syntax and more information.
Produces a result table consisting of qualifying rows from the specified table. See SELECT for the statement syntax and more information.
Updates rows that meet a specified condition from a table or view. Updating a row in a view updates the row in the table on which the view is based. See UPDATE for the statement syntax and more information.
You can also perform the transaction level operations with the following Data Manipulation Language commands.
Terminates a unit of recovery and commits the database changes that were made by that unit of recovery. See COMMIT WORK for the statement syntax and more information.
Ensures against repeatable reads and provides an isolation level protection from other executing programs. See LOCK TABLE for the statement syntax and more information.
Terminates a unit of recovery and backs out the CA Datacom/DB database changes made by that unit of recovery. See ROLLBACK WORK for the statement syntax and more information.
Note: The COMMIT WORK and ROLLBACK WORK commands can be placed in a source member to be executed, if necessary. A COMMIT WORK command is implied, in CICS, by a transaction boundary (that is to say, from EXECUTE to display of results is a single transaction). A ROLLBACK WORK is implied, in all environments, by a negative SQL return code (in the format -nnn) on any SQL statement in the member being executed.
|
Copyright © 2014 CA.
All rights reserved.
|
|