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:
K indicates a Request Qualification Area Order-By Section. P indicates a Request Qualification Area Parameter Section.
The number of entries in this section.
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 to be performed on this line:
Insert
Delete
Change
Displays the internal sequence value which specifies the amount PF7 and PF8 scroll the display.
Indicates the location of this section in the Request Qualification Area.
Indicates the order direction as follows:
Ascending (default)
Descending
E - Element
5-character CA Datacom/DB name of the element containing the data to be used in ordering.
Security code (in hexadecimal) for the specified element.
Offset within specified element, relative to zero, of the first byte to be used in ordering.
Number of bytes to be used in ordering.
Identifies the data type of the element as follows:
Character
Packed decimal with preferred signs
Packed decimal with any valid sign
Binary
Zoned decimal with F high-order nibble
Zoned decimal with any high-order nibble
Single precision floating-point
Double precision floating-point
Identifies the signed or unsigned characteristic:
Signed
Signed, positive numeric values only
Unsigned
Parameter Section
The Parameter Section displays a series of lines, each of which begins with the following two fields:
Action to be performed on this line:
Insert
Delete
Change
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 |
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|