CA Dataquery Administrator Overview › Required CA Dataquery Skills

Required CA Dataquery Skills

Learn about CA Dataquery so that you can support your users. Also, you need to be fully authorized so that you can use all the CA Dataquery features if you need to. The following highlights those subjects that are of particular importance to you. You should know how to perform the following tasks:

• Establish security.

  Choose the SECURITY CONTROL option from the Administrative Menu. With this panel you can:

  • Authorize users to access tables and perform the FIND, UPDATE, INSERT, or ERASE functions.
  • Authorize users to access columns protected by profile-codes.
• Authorize a user.
  • Use the USERS option from the Administrative Menu.
  • Type USERS on the command line.

  With this you can add, delete, or maintain users.

• Force a user to log off.

  Use the USERS option from the Administrative Menu. Use the PF key to display the Directory of Active Users. Use a PF key to FORCE OFF the active user.

• Override predefined system defaults for a user.

  Use the USERS option on the Administrative Menu.

• Use diagnostics.

  See Using DQL Diagnostics for details.

• Get CA Dataquery statistics.

  See Using CA Dataquery Statistics for details.

• Create and modify JCL members for batch submission.
• Maintain the Query Library Table (DQQ).
• Perform online library maintenance with the online Administrator functions described in Accessing the Online Administrative Functions.

  You can use the DQLIBRMT utility to:

  • Delete all or selected members for selected users or groups
  • Back up all queries, dialogs, terms, JCL, and PROC members or selected members from the Query Library Table to tape or disk
  • Restore all or selected members to the Query Library Table from a tape or disk file
  • Print maintenance reports that:
    • List each user's query and type
    • Show selected user's query text or JCL
    • Show maintenance functions per query
    • List any errors that occur during query maintenance
• Create and send a message.

  Use the USERS option from the Administrative Menu. Use the PF key to get to the Directory of Active Users. Then use the PF keys to do a CREATE MSG or a SEND MSG.

• Broadcast a message.

  CA Dataquery displays a bulletin board immediately after a user signs on. The bulletin board can be used to distribute information to all CA Dataquery users. Select the LANGUAGE option on the Administrative Menu. For details, see Changing the Bulletin Board.

• Cancel a user's query while it is processing.

  Use the USERS option from the Administrative Menu. Use the PF key to get to the Directory of Active Users. Then use the PF key to do a CANCEL FIND.

• Use the Printer Control option on the Administrative Menu. For details, see Using the Printer Control.
• Disallow use of a query.

  If a query is being used that is causing system problems, you can use the CA Dataquery Administrator Library Maintenance function to change the author's name to an unknown author and make the query private. This keeps the query from appearing in the user's library. This does not delete the query but keeps it from being used until the problem is resolved.