|
art_aggIn case of a combined Select instruction of two tables (join selection), keywords are used to link the master table to Entity 1 and the relationship table. Entity 1 ------+ +------- Entity 2 | | relationship table |
![]() |
Where clauses of this type can only be used in combined select instructions ('select', 'where', 'exec_select'). The first variable of the parameter list of the Select command must be linked to a table field of the master table of Entity 1. |
Syntax: art_agg Example: Combined Select instructions in the action part of a decision table. A database access to the master table of Entity 1 is defined for the 'ENT1' variable. Likewise, a relationship table database access is defined for 'AGG'. "RC" is a variable of type integer. select(ENT1,AGG)
|
|
![]() |
'Select' command, 'exec_select' integer function.
|
art_refIn case of a combined Select instruction of two tables (join selection), keywords are used to link the master table to Entity 2 and the linked table. Entity 1 ------+ +------- Entity 2 | | relationship table |
|
![]() |
This keyword must be used as the argument of a Where condition in combined Select instructions ('select', 'where', 'exec_select'). The first variable of the parameter list of the Select command must be equal to a table field of the master table of Entity 2. |
Syntax: art_ref Example: Combined Select instructions in the action part of a decision table. A database access to the master table of Entity 2 is defined for the 'ENT2' variable. Likewise, a relationship table database access is defined for 'REF'. "RC" is a variable of type integer. select(ENT2,REF)
|
|
![]() |
'Select' command, 'exec_select' integer function.
|
art_typIn case of a combined Select instruction of two tables (Join selection), keywords are used to link the master table to Entity 1 and the type table. Entity -----------type table |
|
![]() |
This keyword must be used as the argument of a Where condition in combined Select instructions ('select', 'where', 'exec_select'). The first variable of the parameter list of the Select command must be equal to a table field of the master table. |
Syntax:art_typ Example: Combined Select instructions in the action part of a decision table. A database access to the master table of the entity is defined for the 'ENT' variable. Likewise, a type table database access is defined for 'TYP'. "RC" is a variable of type integer. select(ENT,TYP) |
|
![]() |
'Select' command, 'exec_select' integer function.
|