Previous Topic: Function Key AssignmentsNext Topic: DBTS/DBTX RQA Order-By and Parameter Section Panel (PF9)


Field Descriptions

The data on the top line of the Selection Section panel is generated by CA Datacom CICS Services and you cannot modify it. The fields displayed on this line are as follows:

TYPE

S indicates that a Request Qualification Area Selection Section is displayed.

CNT

The number of entries in this section.

LTH

If a number is displayed, it indicates the fixed length of each entry. If V is displayed, it indicates variable-length entries.

The Request Qualification Area Selection Section entries specify a search condition in the form of predicates joined by the logical operators AND or OR, where each predicate is composed of a subject, relational operator, and object. The subject is a field in a record. The object can be either another field in the same record, or a literal data value.

For each predicate, the Selection Section panel has three groups of fields:

Each predicate group begins with the following three fields:

RQA POS

Displays the position of this predicate within the Request Qualification Area

ACT

Action to be performed on this predicate. Enter one of the following:

I

Insert

D

Delete

C

Change

SEQ

Displays the order of this predicate within its section of the Request Qualification Area.

The remaining fields on the panel are for the entry of Request Qualification Area Selection Section data. After entering data in each of these fields, use the ERASE EOF key to clear out the extraneous question marks (?). If you use the space bar to erase data in the character fields, CA Datacom CICS Services reads blanks (hexadecimal '40').

Selection Section Operator Fields

LOG

Logical operator specifying relationship between preceding predicate and current predicate:

Blank

required on first predicate

A

AND

O

OR

RELS

Relational operator between subject and object:

GT

Greater than

LT

Less than

GE

Greater than or equal to

LE

Less than or equal to

EQ

Equal to

NE

Not equal to

SP

String present

SA

String absent

IG

Ignore

TYP

Type of comparison:

C

Character comparison for shortest length of 2 operands

P or F

Packed decimal (no alignment)

B

Binary comparison (2, 4 or 8 bytes, logical or arithmetic)

Z or N

Zoned comparison

E

Single precision floating point comparison

D

Double precision floating point comparison

S

Character scan (for SP and SA operators)

SGN

Sign code or skip character:

N or Blank

Logical comparison for numeric fields.

Y

Signed test for numeric comparisons.

P

Positive only (ignore sign for numeric comparisons).

x

(Skip character) Any wildcard character used in string comparisons. Binary zero and space indicate no wildcard character is used.

Selection Section Subject Fields

SCOPE

Indicates one of the following:

E

Element

R

Record (used with SP and SA operators only)

ELMNT

5-character CA Datacom/DB name for the element containing the field to be used as the subject.

SC

Security code (in hexadecimal) for the named element.

OFFST

Offset within element, relative to zero, of the first byte to be used in the subject.

LTH

Number of bytes to be used in the subject. The minimum length is one and the maximum length is the length of the element.

Note: Blanks in both OFFST and LTH indicate that the entire element is used.

Selection Section Object Fields

The element type object fields and the literal object fields are mutually exclusive. When specifying an element type object, identify the field to be used as the object in terms of its offset within an element and its length.

TYP

Indicates the type of object specified:

E

Element object—Fill in only the Element Type following field group.

V

Literal value object—Fill in only the Literal following field group.

The following field groups contain the following fields:

OBJECT (Element Type) (TYP=E)

This field group contains the following fields.

ELMNT

5-character CA Datacom/DB name identifying the element that contains the object.

SC

Security code (in hexadecimal) for the named element.

OFFST

Offset within element, relative to zero, of the first byte to be used in the object.

LTH

Number of bytes to be used in the object. The minimum length is one and the maximum length is the length of the element.

Blanks in both OFFST and LTH indicate that the entire element is used.

OBJECT LITERAL (TYP=V)

This field group contains the following fields.

LTH

Specifies the length of the object, which must be greater than zero and less than or equal to the subject length.

Second Field

This 45-position field is for entry of the literal value with which the subject is compared. (The literal value must be of the same data type and precision as the subject.) To specify a literal longer than 45 positions, use the Main DBTS/DBTX panel to enter data beyond the first 45 positions. To enter packed data, enter the literal in the hexadecimal portion of the Main DBTS/DBTX panel.