- On the Merge dialog box, click on INPUT.
-
Click on locking.
Merge > Input > Locking
-
Optional LOCKING clause text — This field provides the option to enter one or more SQL Locking clauses to change the locking characteristics of one or more input tables. The locking clause or clauses will be placed in different places in the generated SQL depending on the Output - Storage options in effect, whether they call for selecting the data, explaining the Select statement, creating a table or creating a view.
In the following example, two input tables are locked for access,
LOCKING twm_source.twm_customer FOR ACCESS LOCKING twm_source.twm_customer_analysis FOR ACCESS
-
Optional LOCKING clause text — This field provides the option to enter one or more SQL Locking clauses to change the locking characteristics of one or more input tables. The locking clause or clauses will be placed in different places in the generated SQL depending on the Output - Storage options in effect, whether they call for selecting the data, explaining the Select statement, creating a table or creating a view.