explanation for the teradata sql code

alexcol · Post by **alexcol** » Mon Jan 02, 2012 6:37 pm

Good afternon : Im new at Teradata and Could anybody explain to me what this query does ? i dont understand the sentence

CREATE MULTISET TABLE RCC_DATA.TMP_AboMovM_AcctSubs USING _spVV4 (DATE), _spVV3 (DATE)LOCKING TABLE DWH_DATA.ACCOUNT_SUBSCRIPTION ACCESS CREATE MULTISET TABLE RCC_DATA.TMP_AboMovM_AcctSubs , NO BEFORE JOURNAL, NO AFTER JOURNAL,

PaulVL · Post by **PaulVL** » Mon Jan 02, 2012 8:37 pm

And Google says...:

http://readvitamin.com/2007/10/22/creat ... -multiset/

chulett · Post by **chulett** » Mon Jan 02, 2012 10:09 pm

Yah, not a query... and a better question for your DBA than us.