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

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. On the Variable Transformation dialog, click on INPUT.
  2. Click on locking.
    Variable Transformation > Input > Locking

    • Optional LOCKING clause text — 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