ADD and UPDATE Statements

DQ Internal Security › Performing User Table Maintenance (DQUSERMT) › ADD and UPDATE Statements

ADD and UPDATE Statements

For the ADD or UPDATE functions, the second statement in the job stream is ADD or UPDATE.

 ►►──┬─ ADD ────┬───────────────────────────────────────────────────────────────►
     └─ UPDATE ─┘

                                      ┌──────────────────────┐
 ►─ USER=userid ─┬──────────────────┬─▼─┬──────────────────┬─┴────────────────►◄
                 └─ ,option1=value ─┘   └─ ,option2=value ─┘

ADD

To add a new user ID, specify the ADD statement beginning in column 1.

UPDATE

To modify an existing user ID, specify the UPDATE statement beginning in column 1.

USER=

(Required) Beginning in column 11, specify USER= followed by the user ID to add or update.

Valid Entries:: A 1- to 32-character user ID
Default Value:: (No default)

,option1= and ,option2=

(Optional) Following the user ID, code optional keywords which specify the characteristics of the user ID being added or modified.

The available options are listed in ADD and UPDATE Statement Optional Keywords under the following categories:

User Authorization Options
Administrative Functions
Override System Defaults
Profile Options
Printer Options

If you omit an option, CA Dataquery uses the default for that option.

Leave no spaces in the keyword portion of the statement. Use an equal sign (=) to separate an option type from its value, and a comma (,) to separate the options. Do not enter options past column 72. Enter an X (or any non-blank character) in column 72 to indicate that the line is continuing. There are 20 lines allowed for continuations.