Previous Topic: Limit Access to Columns with the Security Control FunctionNext Topic: Using Batch CA Dataquery

Administration Guide › Limit Access to Columns with the Security Control Function › Condition/Restriction Reporting (DQCRRPT) Statements

Condition/Restriction Reporting (DQCRRPT) Statements

SIGN/ON Statement

►►─ SIGN/ON ─ userid ─ PASSWORD ─ password ───────────────────────────────────►◄

REPORT (Restriction Reports)

►►─ REPORT ─ TITLE=RESTRICTION ─┬────────────────────┬────────────────────────►
                                └─ ,TABLE=tablename ─┘

 ►─┬────────────────────────────────────────────────────────────┬─────────────►◄
   ├─ USER ─ NAME=userid ───────────────────────────────────────┤
   └─ GROUP ─ LEVELS= ─┬─ level1 ─┬─────────────────────────┬─┬─┘
                       │          └─ ,level2 ─┬───────────┬─┘ │
                       │                      └─ ,level3 ─┘   │
                       └─ ALL ────────────────────────────────┘

CONDITION Reports

►►─ REPORT ─ TITLE=CONDITION ─┬───────────────────────────┬───────────────────►
                              └─ ,TABLE= ─┬─ tablename ─┬─┘
                                          └─ ALL ◄ ─────┘

 ►─┬────────────────────────────┬─┬─────────────────────────────────┬─────────►◄
   └─ ,RESTRICTIONS= ─┬─ YES ─┬─┘ └─ CONDITION NAME=condition name ─┘
                      └─ NO ──┘

Enter the control statements in the following sequence:

For Condition Reports

For Restriction Reports