Search and Value Buffer Examples

This section contains examples of search and value buffer construction. For the Adabas file definitions used in all the examples in this section, see File Definitions Used in Examples. The values for the value buffer are shown in character and/or hexadecimal notation.

• Example 1: Using a Single Search Expression

• Example 2: Using Search Expressions Connected by AND

• Example 3: Using Search Expressions Connected by OR

• Example 4: Using Search Expressions Connected by FROM-TO

• Example 5: Using Search Expression with BUT-NOT

• Example 6: Using a Multiple-Value Descriptor

• Example 7: Using a Descriptor Within a Periodic Group

• Example 8: Using a Subdescriptor

• Example 9: Using a Superdescriptor with Alphanumeric Format

• Example 10: Using a Superdescriptor with Binary Format

• Example 11: Using Previously Created ISN Lists

• Example 12: Using a Value Operator

• Example 13: Using Both Value and Connecting Operators

• Example 14: Using Physically Coupled Files

• Example 15: Using Single Soft Coupling Criterion and Single Search Criterion

• Example 16: Using Single Soft Coupling Criterion and Multiple Search Criteria

• Example 17: Using Multiple Soft Coupling Criteria and Multiple Search Criteria

• Example 18: Using Multiple Soft Coupling Criteria and Multiple Search Criteria with Physical Coupling

Example 1: Using a Single Search Expression

A search that uses a single search expression.

Select the ISNs of all the records in file 1 that contain the value "12345" for field AA, which has a standard length of eight bytes and numeric format.

AA.

00012345

F0F0F0F1F2F3F4F5

The same search may be performed using "AA,5." (length override) in the search buffer and the value "12345" (without trailing blanks) in the value buffer.

Example 2: Using Search Expressions Connected by AND

A search that uses two search expressions connected by the AND operator.

Select the ISNs of all the records in file 1 that contain the value "12345678" for the field AA, which has a standard length of eight bytes and numeric format, and the value "+2" for the field AB, which has a standard length of two bytes and packed decimal format.

AA,D,AB.

F1F2F3F4F5F6F7F8002C

Select the ISNs of all the records in file 1 that contain the value "12345678" for the field AA, which has a standard length of eight bytes and numeric format, and the value "+2" for the field AB, which has a length of three bytes (override) and unpacked decimal (override) format.

AA,D,AB,3,U.

12345678002

F1F2F3F4F5F6F7F8F0F0F2

This second search produces the same result as the first search, but shows the use of the length and format override in the search buffer.

Example 3: Using Search Expressions Connected by OR

A search that uses three search expressions connected by the OR operator.

Select the ISNs of all the records in file 2 that contain any of the values "284", "285", or "290" for the field XB. Length and format overrides are used.

XB,3,U,O,XB,3,U,O,XB,3,U.

284285290

F2F8F4F2F8F5F2F9F0

Example 4: Using Search Expressions Connected by FROM-TO

A search that uses two search expressions connected by the FROM-TO operator.

Select the ISNs of all the records in file 2 that contain any value in the range "+20" through "+30" for the field XB.

XB,S,XB.

020C030C

Example 5: Using Search Expression with BUT-NOT

A search that uses three search expressions connected by the FROM-TO and BUT-NOT operators.

Select the ISNs of all the records in file 2 that contain any of the values in the range "+20" through "+30" but not "+27" for the field XB.

XB,S,XB,N,XB.

020C030C027C

Select the ISNs of all the records in file 2 that contain any of the values in the range "+1" through "+200" or "+500" through "+600" for the field XB.

XB,S,XB,O,XB,S,XB.

001C200C500C600C

Example 6: Using a Multiple-Value Descriptor

A search in which a multiple-value field is used.

Select the ISNs of all the records in file 1 that contain the value "ABC" for any value of the multiple-value field MF.

MF.

ABC 

C1C2C3

It is not possible to limit the search to a specific occurrence of a multiple-value field. The following search buffer entry is invalid:

MF2.

Example 7: Using a Descriptor Within a Periodic Group

A search in which a descriptor within a periodic group is used.

Select the ISNs of all the records in file 1 that contain the value "4" in any occurrence of the descriptor BA (which is contained in a periodic group).

BA.

04

Select the ISNs of all records in file 1 that contain the value "4" in the third occurrence of the descriptor BA (which is contained within a periodic group).

BA3.

04

Example 8: Using a Subdescriptor

A search that uses a subdescriptor. SA is a subdescriptor derived from the first four bytes of the field RA.

Select the ISNs of all the records in file 2 that contain the value "ABCD" for the subdescriptor SA.

SA.

C1C2C3C4

Example 9: Using a Superdescriptor with Alphanumeric Format

A search that uses a superdescriptor with alphanumeric format. SB is a superdescriptor derived from the first eight bytes of the field RA and the first four bytes of the field RB.

Select the ISNs of all the records in file 2 that contain the value "ABCDEFGH1234" for the superdescriptor SB.

SB.

C1C2C3C4C5C6C7C8F1F2F3F4

Example 10: Using a Superdescriptor with Binary Format

A search that uses a superdescriptor with binary format. SC is a superdescriptor derived from the fields XB and XC.

Select the ISNs of all the records in file 2 that contain the value "+20" for the field XB and the value "123456" for the field XC.

SC.

020FF1F2F3F4F5F6

Example 11: Using Previously Created ISN Lists

A search that uses previously created ISN lists (identified by their command IDs).

Select the ISNs present in both ISN lists identified by the command IDs "CID1" and "CID2".

(CID1),D,(CID2).

Select the ISNs of all the records in file 1 for which an ISN is present in the ISN list identified by "CID1" and which contain the value "+123" for the field AB.

(CID1),D,AB,3,U.

123

F1F2F3

Example 12: Using a Value Operator

A search in which a value operator is used.

Select the ISNs of all the records in file 1 that contain a value greater than "+100" for the field AB.

AB,3,U,GT.

100

F1F0F0

Example 13: Using Both Value and Connecting Operators

A search in which both value and connecting operators are used.

Select the ISNs of all the records in file 1 that contain a value greater than "+100" for the field AB and a value greater than "A" for the field AA.

AB,3,U,GT,D,AA,1,GT.

100A

F1F0F0C1

Example 14: Using Physically Coupled Files

A search using search expressions that refer to physically coupled files.

Select the ISNs of all the records in file 1 that contain the value "+20" for the field AB and are coupled to records in file 2 that contain the value "ABCDE" for field RB. Length and format override are used for field AB.

/1/AB,3,U,D,/2/RB.

020ABCDEbbbbb

F0F2F0C1C2C3C4C54040404040

Example 15: Using Single Soft Coupling Criterion and Single Search Criterion

The file for which ISNs will be returned is determined by the file number field.

(4,AB,1,AC)/1/AB,S,AB.

-------------

1. Search file 1 for AB = value as provided in value buffer.

2. For each resulting ISN in file 1, read field AC and internally match the value with the corresponding value list for file 4. The resulting ISN list from file 4 is provided in the ISN buffer.

Example 16: Using Single Soft Coupling Criterion and Multiple Search Criteria

The file for which ISNs will be returned is determined by the file number field. The order in which the criteria are specified is arbitrary.

(1,AA,2,AB)/1/AC,D,AE,D,/2/AF,S,AF.

-------------

1. Search file 2 for AF = ... through ... (values in value buffer)

2. For each resulting ISN in file 2, read field AB and internally match the value with the corresponding value list for file 1.

3. Search file 1 for AC = ... and AE = ... (values in value buffer).

4. Match resulting ISN lists from steps 2 and 3. The resulting ISNs are provided in the ISN buffer.

Example 17: Using Multiple Soft Coupling Criteria and Multiple Search Criteria

(1,AA,2,AB; 1,AA,5,BA)

/1/AC,D,AE,D,/2/AF,S,AF,D,/5/BC,S,BC.
          

-------------

1. Search file 2 for AF = ... through ... (values in value buffer).

2. For each resulting ISN in file 2, read field AB and internally match the value with the corresponding value list for file 1.

3. Search file 5 for BC = ... through ... (values in value buffer).

4. For each resulting ISN in file 5, read field BA and internally match the value with the corresponding value list for file 1.

5. Search file 1 for AC = ... and AE = ... (values in value buffer).

6. Match resulting ISN lists from steps 2, 4 and 5. The resulting ISNs are provided in the ISN buffer.

Example 18: Using Multiple Soft Coupling Criteria and Multiple Search Criteria with Physical Coupling

(1,AA,2,AB)
/1/AC,D,AE,D,/2/AF,S,AF,D,/5/BC,S,BC.

-------------

1. Search file 2 for AF = ... through ... (values in value buffer)

2. For each resulting ISN in file 2, read field AB and internally match the value with the corresponding value list for file 1.

3. Search file 5 for BC = ... through ... (values in value buffer)

4. For each resulting ISN in file 5, use the physical coupling lists created by the ADAINV utility to perform ISN matching. This is done since no soft coupling criteria was provided from file 5 to the main file (file 1). If a physical coupling list does not exist, any ISNs from file 5 will not be considered.

5. Search file 1 for AC = ... and AE = ... (values in value buffer).

6. Match resulting ISN lists from steps 2, 4 and 5. The resulting ISNs are provided in the ISN buffer.