Datacom DQRY menu missing option PDB
Article ID: 133651
Updated On:
Products
Issue/Introduction
Datacom Dataquery DQRY menu does not show the option for PDB "Personal Database Tables" for a certain user.
Environment
Release : All
Component : CA Datacom DATAQUERY CICS
Resolution
Assure that the Datacom Multi-user (MUF) is started with the SQL option enabled.
Then, a DQRY Administrator should update the specific user to assure the following attributes are specified:
QUERY LANGUAGE is set to SQL not DQL mode
The following should be set to "Y" (yes):
- PERSONAL DATABASE
- SQL AND DQL ALLOWED
- SQL DATA DEF ALLOWED
- SQL DATA MAINT ALLOWED
For example:
=>
Enter the user information and press the appropriate PF key
--------------------------------------------------------------------------DQUU0
DATAQUERY: USER TABLE MAINTENANCE
-------------------------------------------------------------------------------
USER NAME : OBRPA03
PASSWORD : GROUPS:
ACCOUNTING CODE : LEVEL 1:
QUERY LANGUAGE : sql LEVEL 2:
PRIVATE SQL AUTHID : sysadm LEVEL 3:
DQ SYSTEM STATUS.
DATA AUTHORIZED : N ASSOCIATE USER : N PERSONAL DATABASE : y
SUBMIT ALLOWED : Y EXPORT ALLOWED : Y
SQL AND DQL ALLOWED : y SQL DATA DEF ALLOWED : y SQL DATA MAINT ALLOWED : y
SYSTEM ADMINISTRATIVE MENU ITEMS AUTHORIZED FOR.
CONDITIONS : N RESTRICTIONS : N PRINTER CONTROL : N
JCL MAINTENANCE : N DIAGNOSTICS : N LANGUAGE : N
USER MAINTENANCE : N SAVED SET MAINT : N QUERY LIBRARY MAINT : N
SECURITY : N ACTIVE USER CONTROL : N
. . .
Once the user has been updated, option 4 for PDB will present:
=>
--------------------------------------------------------------------------DQZ5
DATAQUERY: MAIN MENU - SQL MODE
ENTER THE NUMBER OF THE DESIRED FUNCTION ===> _
1. DIRECTORIES - Lists of Queries and Tables
2. CREATE - Query, Dialog creation
3. GUIDE - Structured query creation
4. PDB - List, create and maintain personal tables
5. ADMINISTRATION - DATAQUERY system management
6. HELP - Display Help Information
7. OFF - DATAQUERY session termination
Additional Information
Refer to Datacom Core - 15.1 section "(DQZ50) Main Menu (SQL Mode)" which states:
"Note: PDB only appears for those users authorized to use the feature. PDB does not appear if the CA Datacom®/DB SQL option is not installed."
Feedback
