Parameter Expansions › Expansion of boolean-expression › Parameters

Parameters

NOT

Specifies that the opposite of the condition fulfills the test requirements.

comparison

'character-string-literal'

Specifies an alphanumeric literal enclosed in single quotes.

numeric-literal

Specifies a numeric literal which can be preceded by a minus sign. In numeric literals, if the current decimal point default is a comma, a period (.) is interpreted as an insertion character, and a comma (,) is interpreted as a decimal point.

arithmetic-expression

Specifies an arithmetic expression specified as a minus sign (-), as a simple arithmetic operation, or as a compound arithmetic operation. Arithmetic operators permitted in an arithmetic expression are +, -, *, and /. Operands can be a numeric literal, logical-record field, or database field.

db-record-field

Specifies a data field that participates in the database record named in the path DML command. The field can occur in a record that is accessed but that does not participate in a logical record.

Note: Expanded syntax for db-record-field is presented in this chapter.

lr-field of LR

Specifies a data field that participates in the logical record. The OF LR entry is required; it indicates that the value of the named field has been placed in the logical record's variable-storage location by a previous path DML command.

Note: Expanded syntax for lr-field is presented in this chapter.

EQ/IS/=

Indicates that the value of the left operand must equal the value of the right operand for the boolean expression to be true. EQ, IS, and = are synonymous.

NE

Indicates that the value of the left operand must not equal the value of the right operand for the boolean expression to be true.

GT/>

Indicates that the value of the left operand must be greater than the value of the right operand for the boolean expression to be true. GT and > are synonymous.

LT/<

Indicates that the value of the left operand must be less than the value of the right operand for the boolean expression to be true. LT and < are synonymous.

GE

Indicates that the value of the left operand must be greater than or equal to the value of the right operand for the boolean expression to be true.

LE

Indicates that the value of the left operand must be less than or equal to the value of the right operand for the boolean expression to be true.

CONTAINS

Indicates that the value of the right operand is contained in the value of the left operand. The value of the right operand must not be longer than the value of the left operand. Note that each operand included with the CONTAINS operator can be a logical-record field name, database record field name, or alphanumeric literal. The fields must be defined as alphanumeric or unsigned zoned decimal values and must be an elementary item.

MATCHES

Indicates that each character in the left operand matches a corresponding character in the right operand (the mask). When MATCHES is specified, CA IDMS/DB compares the left operand with the mask, one character at a time, moving from left to right. The result of the match is either true or false: the result is false if CA IDMS/DB encounters a character in the left operand that does not match the corresponding character in the mask; the result is true if CA IDMS/DB reaches the end of the mask before encountering a character in the left operand that does not match a mask character. Three special characters can be used in the mask to perform pattern matching, as follows:

Note that each operand included with the MATCHES operator can be a logical-record field name, database record field name, or alphanumeric literal. The fields must be defined as alphanumeric or unsigned zoned decimal values and must be elementary items.

AND

Indicates the expression is true only if the outcome of both test conditions is true.

OR

Indicates the expression is true if the outcome of either one or both test conditions is true.