Previous Topic: Supported SQL Language ElementsNext Topic: Data Types

SQL Concepts and Language Elements › Supported SQL Language Elements › Condition

Condition

CA Ideal supports SQL basic predicates and standard SQL relational operators in embedded SQL and FOR constructs with SQL dataviews.

The following SQL relational predicates are supported:

In addition, you can use the following PDL relational operators in embedded SQL predicates:

Relational Operators

Symbol

EQUAL

EQ

NOT EQUAL

NE

GREATER THAN

GT

NOT GREATER THAN

LE

LESS THAN

LT

NOT LESS THAN

GE

The symbol ¬ can replace NOT. THAN is optional.

You can combine conditional expressions using AND and OR. You can use the characters & and | for AND and OR, respectively.

PDL implied subjects and implied operators do not apply in embedded SQL conditions.