Table of Contents:

Supported Lookups

Example of a supported SELECT statement

SELECT */list_of_fields (aggregation_functions-SUM, MIN, MAX) (AS)
INTO (CORRESPONDING FIELDS OF) TABLE result_table
FROM DSO_active_table
(FOR ALL ENTRIES IN fae_table)
WHERE (fae_table_cond AND ) where_cond-BETWEEN,OR,IN,().

Example of a supported WHERE condition

manager = fae_table-manager AND (city = ‘FRANKFURT’ OR city = ‘BERLIN’)

Example of a not supported WHERE condition

manager = fae_table-manager OR manager = ‘PETER’ AND (city = ‘FRANKFURT’ OR (country = ‘SVK’ AND date = ‘01012014’) )

Not supported lookups

1. SELECT - ENDSELECT

Selects data and stores the result into a structure or variables
Contains processing executed for each row

2. SELECT DISTINCT

DISTINCT used in SELECT ensures only unique combinations of field values are selected
This SELECT is not supported by Lookup API and SNP OutBoard™ Data Tiering

3. SELECT aggregation function INTO variable

The result of an aggregation function is stored in a variable.

4. SELECT with WHERE containing IN table

An internal table is used in WHERE condition IN
This SELECT is neither supported by Lookup API, nor SNP OutBoard™ Data Tiering

5. SELECT with dynamic WHERE condition

Internal table containing WHERE condition is used in SELECT
This SELECT statement isn't supported by Lookup API or by SNP OutBoard™ Data Tiering

6. SELECT SINGLE

Selects the first row matching the selection and stores it into a structure – not supported by API
API requires a table for results, all rows matching the selection are returned

7. SELECT with ORDER BY:

During data selection, both active and archived data is read.
Sorting data from different sources is not supported by Lookup API.

8. JOIN

Join combines data of multiple tables – this is not supported by Lookup API
Without knowing the business logic behind it, it’s complicated to understand which data is selected

Supported Lookups

Example of a supported SELECT statement

Example of a supported WHERE condition

Example of a not supported WHERE condition

Not supported lookups

1. SELECT - ENDSELECT

Recommended solution

2. SELECT DISTINCT

Recommended solution

3. SELECT aggregation function INTO variable

Recommended solution

4. SELECT with WHERE containing IN table

Recommended solution

5. SELECT with dynamic WHERE condition

Recommended solution

6. SELECT SINGLE

Recommended solution - Field routine

Recommended solution - Loop

7. SELECT with ORDER BY:

Recommended solution

8. JOIN

Recommended solution

9. NATIVE SQL

Recommended solution

Browser not supported