SAP Open/SQL Support

The following table describes the conversion that takes places from the FOCUS statements to the SAP Open/SQL statements.

FOCUS Command

Corresponding Open/SQL statement

READLIMIT

UP TO n ROWS

When a multiple SELECT statement is generated, READLIMIT is translated in UP TO n ROWS for each individual SELECT.

WHERE

Generally translated into a WHERE statement.

JOIN TO

For each table included in the JOIN command, embedded SELECT statements are created.

JOIN

Translated into SELECT ... SELECT SINGLE ...

NULL

The Adapter for SAP does not support the use of the reserved word 'NULL' as part of a WHERE clause. Including 'NULL' as part of a WHERE clause results in a syntax error.

SUM ...

BY

By default, the aggregation feature is turned off. If the aggregation is turned off, individual rows are selected and aggregation and sorting is done by FOCUS. It can be turned on by issuing

ENGINE SQLSAP SET OPTIMIZATION SQL

Once the aggregation is turned on, the SUM is translated into SUM and the BY is translated into GROUP BY and ORDER BY.

The aggregation feature only applies to TRANSPARENT tables.


WebFOCUS