Data Manipulation Language Statements › @IF—tests for the presence of member record occurrences › @IF Parameters

@IF Parameters

SET=set-name

Identifies the set that is to be tested for existing member record occurrences. Set-name must specify a set included in the subschema.

MEMBER=

Determines whether the current record of run unit participates as a member in any occurrence of the named set and, depending on the outcome of the evaluation, executes the branch statement.

YES

Specifies that the branch statement is executed only if the record is a member of the set (that is, ERRSTAT is 0000).

NO

Specifies that the branch statement is executed only if the named record is not a member of the named set (that is, ERRSTAT is 1601).

EMPTY=

Evaluates the current occurrence of the named set for the presence of member record occurrences and, depending on the outcome of the evaluation, executes the branch statement.

YES

Specifies that the branch statement is executed only if the set is empty (that is, ERRSTAT is 0000).

NO

Specifies that the branch statement is executed only if the specified set has one or more member records (that is, ERRSTAT is 1601).

GOTO=branch-location

Identifies the next statement in the program be executed. Branch-location must be a statement label; register notation is not supported for this parameter.

ERRSTAT=status-location

Specifies the name of the status field in the IDMS communications block. If the status field is other than ERRSTAT, this clause is required. Status-location must be a statement label; register notation is not supported for this parameter