Adding users to CA Dataquery in batch mode

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

How can I set up new users with their authorizations in CA Dataquery using batch jobs?

Environment

Component : CA Dataquery for CA Datacom

Resolution

To maintain the CA Dataquery User Table (DQU), there is a utility called DQUSERMT. This is explained in the Core documentation, in the Administration section.

One important thing to note here is that the input to this utility is column-specific.

Here is an example input showing different commands - there are more explanations in the documentation.

//SYSIN    DD   *                                                         
SIGN/ON DATACOM-INSTALL PASSWORD NEWUSER                                  
ADD       USER=DJ-TEST1,SUBMIT=Y,EXPORT=Y,SQLDQL=Y,SQLDDEF=Y,          X  
          JCLMNT=Y,QRYLMNT=Y,SECMNT=Y,USERMNT=Y,SQLDMNT=Y,AUTHID=SYSUSR   
REPORT    USER=DJ-TEST1                                                   
ADD       USER=DJTEST2 COPYFROM=TESTUSE1
REPORT    USER=*ALL*
/*                                                             

Additional Information

As always, please contact Broadcom support for CA Datacom if you have further questions.