Entering content frame

Predicate (predicate) Locate the document in its SAP Library structure

A predicate (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 or to a group of rows in a table that was formed by the GROUP condition.

Syntax

<predicate> ::=
  <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 can be compared.

·        Columns that have different code attributes such as ASCII and UNICODE can be compared.

·        Columns with the code attribute ASCII or UNICODE can be compared with date values, time values, or time stamp values.

·        LONG columns can only be used in the NULL predicate (null_predicate) .

Example

Selection with comparison condition:

SELECT title, name
  FROM customer
    WHERE title = 'Company'

Selection of customers that are companies

TITLE

NAME

Company

Datasoft

Company

TOOLware

 

 

Leaving content frame