ADD_JOIN_DEFINITION

Add an external join definition.

Parameter Name	Required	DefaultValue	Parameter-Description
p_join_name	yes		join definition name
p_join_obj_schema	yes		join object schema
p_join_obj_table	yes		join object name
p_left_join	yes		use left join (true: left join, false: innner join)
p_join_expression	yes		join expression
ARRAY p_tsa_tables	yes		array (‘Join Order, TSA schema, TSA table, BDomain, Join Alias Name’, …)
ARRAY p_tsa_join_cols	yes		array (‘Join Order, TSA Join Position, TSA Join Column’, …)
ARRAY p_join_retcols	yes		array (‘return column name; optional expression for return column; return column datatype’, …) - due to the expression it is necessary that the delimiter is a semicolon “;”
p_join_description	no		join description

Example

EXECUTE SCRIPT api_reppsa.add_join_definition
           ( 'XXX'       -- p_join_name
           , 'XXX'       -- p_join_obj_schema
           , 'XXX'       -- p_join_obj_table
           , 'XXX'       -- p_left_join
           , 'XXX'       -- p_join_expression
           , ARRAY ('JoinOrder1,TSA-Schema1,TSA-Table1,BDomain1,Join-Alias1'
                   ,'JoinOrder2,TSA-Schema2,TSA-Table2,BDomain2,Join-Alias2'
                   )     -- ARRAY p_tsa_tables
           , ARRAY ('JoinOrder1,TSA-JoinPos1,TSA-JoinCol1'
                   ,'JoinOrder2,TSA-JoinPos2,TSA-JoinCol2'
                   )     -- ARRAY p_tsa_join_cols
           , ARRAY ('returnColName1,optExpr4returnColumn1,retColDatatype1'
                   ,'returnColName2,optExpr4returnColumn2,retColDatatype2'
                   )     -- ARRAY p_join_retcols
           , 'XXX'       -- p_join_description
           );