Generation of the data flow in SQL access mode
Typical structure
BEGIN_STD_DFL NUM_E(15,0) SQL_RET_CODE LOADING LDG_ENTITY2<window.object:list_prop> *SQL ENTITY1 - *COND(.....) *SORT(.....) LoadingStep END_STD_DFL |
The condition generated depends on the access path specified and the access type defined for the list loading.
If a load step has been specified, it appears at the end of the load declaration.
As regards the host variables of the SQL condition, those taken into account are:
The first Input/Output screen field whose origin is the logical property defined in the entity's access.
The first screen field whose original logical entity is different from the entity processed, but has the same original conceptual property.
The field of the entity which constitutes the access.
The sort is made according to the following rule:
If the entity key is convenient for the access path indicated, the sort will affect all the fields which constitute the key.
If it is not, choose the first access with a convenient path, and the sort will affect the entire key of the access.
Otherwise, the sort will only affect the fields which constitute the path indicated.
Click below for further information about: