Getting 'INVALID COMMAND' when running ERASE or UPDATE via DQBATCH DQL mode
Article ID: 43643
Updated On:
Products
Issue/Introduction
Question:
Why am I getting ‘INVALID COMMAND’ when I run DQBATCH DQL statement
ERASE ALL AUSSENSTAND WITH ERZEUGDATUM = 20160531 ?
Environment:
z/VSE z/OS
Answer:
CA Dataquery was never designed to run table maintenance in batch via DQBATCH DQL Mode .
That is documented in the CA Dataquery Administration Guide
Chapter 18. Modifying Data Using Advantage CA-Dataquery
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 Advantage CA-Datacom/DB databases. The user must be explicitly authorized for each function for each table to perform this maintenance. See “Part IV. Securing Advantage CA-Dataquery” on page 22-3.
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 Chapter 24,“Authorizing Users” for more information.
Environment
Component:
Feedback
