- On the Variable Creation dialog, click on INPUT.
-
Click on locking.
Variable Creation > INPUT > Locking
This provides the following option.
- Optional LOCKING clause text — 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. For example, the locking clauses below will result in generated SQL that looks similar to one of the forms outlined below.
LOCKING twm_source.twm_customer FOR ACCESS LOCKING twm_source.twm_customer_analysis FOR ACCESS
Variable Creation - INPUT - Locking Output Storage Option Generated SQL Form Select LOCKING twm_source.twm_customer FOR ACCESS LOCKING twm_source.twm_customer_analysis FOR ACCESS
SELECT ...
FROM twm_source.twm_customer ...
Explain EXPLAIN LOCKING twm_source.twm_customer FOR ACCESS
LOCKING twm_source.twm_customer_analysis FOR ACCESS SELECT ...
FROM twm_source.twm_customer ...
Create Table LOCKING twm_source.twm_customer FOR ACCESS LOCKING twm_source.twm_customer_analysis FOR ACCESS CREATE SET TABLE ... AS (
SELECT ...
FROM twm_source.twm_customer ...
) WITH DATA PRIMARY INDEX ...
Create View CREATE VIEW ... AS LOCKING twm_source.twm_customer FOR ACCESS
LOCKING twm_source.twm_customer_analysis FOR ACCESS (SELECT ...
FROM twm_source.twm_customer ... )