EXISTS

The EXISTS function determines whether an object is defined in any attached workspace. The EXISTS function is useful in a program to test whether a definition exists before you try to use it.

Return Value

BOOLEAN

Syntax

EXISTS(name-expression)

Parameters

name-expression: A text expression that specifies the name you want to test.

Usage Notes

OLADM1609Specifying More Than One Name

When name-expression contains multiple object names, EXISTS returns NO even when all the objects specified by name-expression exist in attached workspaces.

Examples

OLADM1610 Example 7-79 Using EXISTS

This example tests whether the variable actual has been defined in any attached workspace. The statement

SHOW EXISTS('actual')

produces the following result.

YES