Embedded Files
Join {}
The properties are used to alter the default WOW behavior for handling a join.
TODO: [P3] Add links to JOIN INSERT, UPDATE, DELETE along with example JOIN property groups.
[PRO] This is an optional property group that can be used when the operation query contains a join.
Example: (For SQL SERVER)
Join { updateTables:QCA_STG_PRD.UCS.TBLUSECASEATTRIBUTES;
insertTables:QCA_STG_PRD.UCS.TBLUSECASEATTRIBUTES;
deleteTables:QCA_STG_PRD.UCS.TBLUSECASEATTRIBUTES;
}
* NOTE: YOU MUST INCLUDE THE LIBRARY or SCHEMA I.E. (updateTables: library.table;)
Example: (MYSQL)
Join { insertTables:DOGFOOD.DEVICE; updateTables:DOGFOOD.DEVICE; deleteTables:DOGFOOD.DEVICE; }
LayoutDisplay {}
This property group allows you to override the layout display properties for this operation.
Page updated
Report abuse