Row-Level Security Screens › Row-level Security Selection Screen—RSEL

Row-level Security Selection Screen—RSEL

Description

The Row-Level Security Selection screen allows you to select certain rows of the $SECURITY-RUNTIME-TABLE$ for display.

Access

You can access the Row-Level Security Selection screen by typing RSEL in the screen name field of any screen.

Sample Screen

                                                CA
  RSEL   CA - Automatic System Facility       *Row Level Security Selection*
  DC560603 ENTER SELECTION CRITERIA
  Table Name:
               _ PF1 - Help      _ PF2 - Message Screen          Page:  1  of  1

   ID           Column Name                      Selection Criteria
  0001 GROUP
  0002 USER
  0003 OWNER
  0004 SECURITY-NAME
  0005 STATUS                           ne 'v'
  0006 WHERE-CLAUSE
  0007 GROUP-SEQUENCE-NUMBER
  0008 TIME-STAMP
  0009 DATE-STAMP
  0010 WORK-GROUP




                          Additional Selection Criteria

Fields

Table Name

Displays the name of the table, $SECURITY-RUNTIME-TABLE$.

[PF1] - Help

Invokes the Help screen.

[PF2] - Message Screen

Invokes the Message screen which displays error messages should you enter something incorrectly.

Page ___ of ___

Displays the current screen page number and the total number of pages in the page set. You can move to a particular page by specifying its page number, page forward by using [PF8], and page backward by using [PF7].

ID

Displays the column ID number that can be used to reference the column in selection criteria.

Column Name

Displays the name of each column defined for the table.

Selection Criteria

Enter fixed-format expressions to select rows based on column values. Fixed-format expressions are explained in the chapter "Basic Screens". Enter the expression next to the name of the appropriate column(s). If you enter selection criteria for more than one column, you are indicating that only those rows that meet all criteria for all columns are to be displayed.

Additional Selection Criteria

Enter freeform expressions to select rows based on compound conditions. Freeform expressions can include compound conditions using the logical operators AND, OR, NOT, &., |, and ¬. Freeform expressions can be used in addition to, or instead of, fixed-format expressions to specify selection criteria. When used in conjunction with fixed-format expressions, freeform expressions can be used to override the implied AND connecting fixed-format expressions. Freeform expressions are discussed in the chapter "Basic Screens".