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
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:
_spVV0 (VARCHAR(32000), CHARACTER SET LATIN, NOT CASESPECIFIC),
_spVV4 (DECIMAL(15,0))CALL SYS_DYN_SP.SysExecSQL (:_spVV0 ||_UNICODE '0000'XC,
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.