|
|
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:
"Example 1
Collect demographics on table_1 in database db_1 and write the results
into
the
DataDemographics table of user-defined QCD MyQCD.
COLLECT DEMOGRAPHICS FOR db_1.table_1 INTO MyQCD;"
Regards,
Victor
| |