Understanding the expression USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS

General
Enthusiast

Understanding the expression USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS

Good evening

Im new at Teradata but in in Teradata Manager Tool in the explain tab i stumbled with the expression:

USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS

I tried to find out exactly what it means the above query, but didnt,

I now that has something to do with store procedure languaje with comprises evaluating expressions?

I assume that it declares a variable called VO as date but no more

1. could anybody explain exactly what that expressions does, and if it is a query statement ?

2. where can i find a thorough description about the above expression?

I'd appreciate your help,Thanks 

 

1 REPLY
Enthusiast

Re: Understanding the expression USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS

That is just indicating that whatever statement was running had host variables that were passed into the SQL. Here is an example of one I pulled out of our query log:

USING

      _spVV0 (VARCHAR(32000), CHARACTER SET LATIN, NOT CASESPECIFIC),

      _spVV4 (DECIMAL(15,0))CALL SYS_DYN_SP.SysExecSQL (:_spVV0 ||_UNICODE '0000'XC,

:_spVV4 );

This just shows that 2 host variables were passed into the SQL. Teradata replaces the actual parameter names with these names.

It appears that the rest of the statement was cut off in your case.