DQBATCH OPTION QUERYLANG=SQL and External Security

Products

• Datacom

Issue/Introduction

Symptoms: 

Running DQBATCH using OPTION QUERYLANG=SQL fails with

DQ011E - EITHER THE COMMAND IS UNKNOWN, OR AUTHORIZATION IS DENIED .

 

 

Environment

Datacom 15.1(and below)

Cause

External security has been implemented in the CA Datacom Multi-User for Dataquery SQL non-CICS via path/level DBDQSQQ

 

Resolution

The security administrator must give the user authorization to
cxxname.DQACCESS.DQLSQL

Additional Information

SQL Mode is always secured by CA Datacom/DB and by external security when it is in effect in the Multi-User startup .