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 |