Variable Creation - INPUT - Locking (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. On the Variable Creation dialog, click on INPUT.
  2. 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 ... )