I am trying to add a batch Dataquery user to run our production queries, and I want to model it after an existing user. The existing user has a Description, UserID, and Name entry in the Datadictionary display, but I can't figure out how to add those fields or attributes to my new user.
Do I add the user through Datadictionary or through Dataquery? Do I need to do this in batch mode or online? What steps do I follow?
Here is what I see now in Datadictionary (only selected fields):
ATTRIBUTE VALUE
====== ========================== T O P ========
000001 STATUS P
000002 ENTITY-NAME IOH
. . .
000004 DESCRIPTION BATCH DATAQUERY USER
. . .
000021 USERID IOH
. . .
000024 NAME BATCH DQRY USR
Component: Datacom/DB
Note that there is no functional benefit to adding the description, UserID, and name to this DQ batch user definition. However, if you still want to add them, you can do it through DDOL or through batch DDUPDATE.
First, to create the batch Dataquery user, we would recommend that you would create the user within Dataquery online or batch processes as usual. This will allow you to set all the security and user attributes for Dataquery processing as you need them.
Then, you can use one of these processes, depending on your mode:
-UPD PERSON,xxxxxx (PROD)
1002 'Batch DQ User'
1014 ooo <== Note: this opid starts in col 19
7156 Batch DQ User
-END
-RPT DETAIL,PERSON,xxxxxx (PROD)
-END
/*
As always, please contact Broadcom support for Datacom if you have further questions.