To modify data, the user creates a query containing the appropriate keywords. When the query executes, CA Dataquery presents the Table Maintenance panel. The user checks the panel, then presses the APPLY PF key.
DQL Language
Online CA Dataquery provides three DQL Language functions to modify data. The functions are ERASE, INSERT and UPDATE. These special DQL Language verbs can be used in queries by authorized users to delete, add, or change data contained in CA Datacom/DB databases. The user must be explicitly authorized for each function for each table to perform this maintenance.
Note: In DQL Mode, data manipulation is only available in online processing, that is, you cannot do data manipulation in DQL Mode if you are using batch processing.
SQL Mode
You need authorization to use SQL Data Maintenance to be able to use SQL verbs DELETE, INSERT, and UPDATE. Data Maintenance is available in both online and batch modes to SQL users. See Authorizing Users for more information.
Dialogs
A great deal of flexibility can be obtained by making queries containing these verbs into dialogs. With this technique the user executing the query can be prompted for the column values in INSERT and UPDATE queries. See the CA Dataquery User Guide for more information about dialog creation.
|
Copyright © 2014 CA.
All rights reserved.
|
|