Previous Topic: Function Key AssignmentsNext Topic: DBTS Example - Simulating Program Logic


Field Descriptions

The data on the top line of the Order-By Section and on the top line of the Parameter Section is generated by CA Datacom CICS Services and you cannot modify it. The fields displayed on each of these lines are as follows:

TYPE

K indicates a Request Qualification Area Order-By Section. P indicates a Request Qualification Area Parameter Section.

CNT

The number of entries in this section.

LTH

For the Order-By Section, it is always 18. For the Parameter Section, indicates the length of the longest parameter.

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

Order-By Section

The Order-By Section specifies the order in which records are to be returned. To indicate an order, specify multiple fields beginning with the major order field and ending with the minor order field. The total length of all fields which you specify must be less than or equal to 160 bytes. To input more than four entries, press Enter to page forward.

ACTION

Action to be performed on this line:

I

Insert

D

Delete

C

Change

SEQ

Displays the internal sequence value which specifies the amount PF7 and PF8 scroll the display.

RQA POS

Indicates the location of this section in the Request Qualification Area.

ORDER CODE

Indicates the order direction as follows:

A

Ascending (default)

D

Descending

TYPE

E - Element

ELMNT NAME

5-character CA Datacom/DB name of the element containing the data to be used in ordering.

SEC CDE

Security code (in hexadecimal) for the specified element.

OFFSET

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

LTH

Number of bytes to be used in ordering.

DATA TYPE

Identifies the data type of the element as follows:

C

Character

P

Packed decimal with preferred signs

F

Packed decimal with any valid sign

B

Binary

Z

Zoned decimal with F high-order nibble

N

Zoned decimal with any high-order nibble

E

Single precision floating-point

D

Double precision floating-point

SIGN/CODE

Identifies the signed or unsigned characteristic:

Y

Signed

P

Signed, positive numeric values only

N or Blank

Unsigned

Parameter Section

The Parameter Section displays a series of lines, each of which begins with the following two fields:

ACTION

Action to be performed on this line:

I

Insert

D

Delete

C

Change

SEQ

Displays the internal sequence value which specifies the amount PF7 and PF8 scroll the display.

Following the ACTION and SEQ fields on each line are a pair of fields. In the first field of the pair specify a 3-character option code. If the option requires data, enter the required data in the second field.

Code

Meaning

Data

UPD

Indicates record to update or delete. (DBTS only)

 

UNQ

Specifies the return of one record for each unique value of the fields listed in the Order-By Section.

 

CNT

Indicates a count of records selected to return.

Enter Y to return the first record after counting.

FST

Specifies maximum number of records to be selected when a temporary set is required.

Number of records to be selected followed by one of the following codes:

A

Any records meeting the selection criteria are to be returned.

When ordering is specified, this means that the records are ordered only within themselves and not within the entire table.

T

The records returned must be a true representation of the table.

This option is meaningful only if an Order-By section is also specified. If T is specified, CA Datacom/DB orders the entire table before returning the first record.

INR

Specifies interrupting selection when nnnnnn records have been selected.

nnnnnn

INF

Specifies interrupting selection when nnnnnn records have been rejected.

nnnnnn

IIO

Specifies interrupting selection when nnnnnn start-I/Os have been performed.

nnnnnn