ADD_JOIN_DEFINITION_TSA

Add an external join definition.

Parameter Name	Required	DefaultValue	Parameter-Description
p_join_name .	yes		join definition name
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’, …)

Example

EXECUTE SCRIPT api_reppsa.add_join_definition_tsa
            ( 'XXX'       -- p_join_name (C) NN / maxLength=80
            , ARRAY ('JoinOrder1,TSA-Schema1,TSA-Tab1,BDomain1,JoinAlias1'
                    ,'JoinOrder2,TSA-Schema2,TSA-Tab2,BDomain2,JoinAlias2'
                    )     -- ARRAY p_tsa_tables
            , ARRAY ('JoinOrder1,TSA-JoinPos1,TSA-JoinCol1'
                    ,'JoinOrder2,TSA-JoinPos2,TSA-JoinCol2'
                    )     -- ARRAY p_tsa_join_cols
            );