Archives of the TeradataForum
Message Posted: Thu, 28 Jun 2007 @ 23:06:32 GMT
| Subj: || || Re: COLLECT DEMOGRAPHICS |
| From: || || Victor Sokovin |
| ||What is the correct syntax to run collect demographics|| |
You can find it in the SQL Reference, Data Definition Statements. Used to be referred to as Volume 4 when SQL Ref consisted of 6 volumes.
Here is an example:
Collect demographics on table_1 in database db_1 and write the results
DataDemographics table of user-defined QCD MyQCD.
COLLECT DEMOGRAPHICS FOR db_1.table_1 INTO MyQCD;"