Predicate (SAP Library - Reference Manual 7.2 (BC))

Predicate

A predicate is specified in a WHERE condition in a statement which is "true", "false", or "unknown". The result is generated by applying the predicate to a specific row in a result table (see result table name) or to a group of rows in a table that was formed by the GROUP clause.

Syntax

between predicate, bool predicate, comparison predicate, default predicate, exists predicate, in predicate, join predicate, like predicate, null predicate, quantified predicate, rowno predicate, sounds predicate

Explanation

Columns in a table with the same code attribute are comparable.

Columns with different code attributes ASCII and EBCDIC (see code tables) can be compared.

Columns with the code attributes ASCII and EBCDIC can be compared with date values, time values, or timestamp values.

LONG columns can only be used in the NULL predicate.

Model table: customer

Selection without a condition:

SELECT city, name, firstname FROM customer

CITY	NAME	FIRSTNAME
New York	Porter	Jenny
Dallas	DATASOFT	?
Los Angeles	Randolph	Martin
Los Angeles	Smith	Sally
Hollywood	Brown	Peter
Washington	Jackson	Michael
New York	Howe	George
Chicago	Miller	Frank
Los Angeles	Peters	Joseph
Los Angeles	Baker	Susan
Los Angeles	Jenkins	Anthony
Los Angeles	Adams	Thomas
New York	Griffith	Mark
Los Angeles	TOOLware	?
Hollywood	Brown	Rose

Selection with restricting condition:

SELECT city, name, firstname FROM customer
WHERE city = 'Los Angeles'

CITY	NAME	FIRSTNAME
Los Angeles	Randolph	Martin
Los Angeles	Smith	Sally
Los Angeles	Peters	Joseph
Los Angeles	Baker	Susan
Los Angeles	Jenkins	Anthony
Los Angeles	Adams	Thomas
Los Angeles	TOOLware	?