LogiView

Predefined Join Conditions art_agg, art_ref, and art_typ

     

art_agg

In 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)
where(art_agg)
RC = exec_select(1)

 

'Select' command, 'exec_select' integer function.

 

 

art_ref

In 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)
where(art_ref)
RC = exec_select(1)

 

'Select' command, 'exec_select' integer function.

 

 

art_typ

In 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)
where(art_ref)
RC = exec_select(1)

'Select' command, 'exec_select' integer function.