Teradata LOCK ROW FOR ACCESS on insert query into a VOLATILE TABLE
<p>I have a <code>VOLATILE TABLE</code> in <code>teradata</code> that i created with the code below</p>

<pre><code>CREATE VOLATILE TABLE Temp 
(
ID VARCHAR(30),
has_cond INT
) ON COMMIT PRESERVE ROWS;
</code></pre>

<p>I want to insert records from a select statement that i have created which is a pretty big SQL statement and definitely requires a row lock before proceeding</p>

<pre><code>INSERT INTO Temp 
(ID ,has_cond)
SELECT * FROM....
</code></pre>

<p>Can anyone tell me how to safely lock the rows so i can insert the records into my <code>VOLATILE TABLE</code> as they are production tables and i don't want to lock out some <code>ETL</code> that might be happening in the background</p>