Listed below are the output properties to modify an existing Sample analysis.
The output properties and their possible values follow:
- OutputStyle — “Select” “CreateTable”, “CreateMultipleTables, CreateMultipleViews”
- OutputDatabase — name of existing database (valid for “CreateTable”, “CreateMultipleTables”, “CreateMultipleViews”)
- OutputName — name of output table to be created (valid for “CreateTable”, “CreateMultipleViews”)
- Fallback (valid for “CreateTable”, “CreateMultipleTables”) — “true” or “false”
- Multiset (valid only if “CreateTable”, “CreateMultipleTables”) — “true” or “false”
- GenerateSqlOnly — “true” or “false”
- AdvertiseOutput (valid for all Create options) — “true” or “false”
-
AdvertiseNote (valid for all Create options) — optional comment or note for advertised output (only used if AdvertiseOutput attribute is “true” or if the Connection element AlwaysAdvertise attribute is “true”)
An XML example to modify the SampleOutputProperties to “CreateTable” follows.
<OutputProperties outputStyle="CreateTable" outputDatabase="twm_results" outputName="MySampleOutput" outputComment="My Sample comment" collectStats="true"/>
For “CreateMultipleTables”, each group of tables is defined by the following XML structure.
<OutputProperties outputStyle="CreateMultipleTables" outputDatabase="twm_results" outputComment="My Sample comment 2" collectStats="true"/> <OutputTables> <OutputTable Name="MySampleTable1"/> <OutputTable Name="MySampleTable2"/> <OutputTable Name="MySampleTable3"/> </OutputTables>
For “CreateMultipleViews”, each group of views is defined by the following XML structure.
<OutputProperties outputStyle="CreateMultipleViews" outputDatabase="twm_results" outputName="MySampleOutputTable" trailingSql="create index("income") on <T>;"/> <OutputViews> <OutputView name="MySampleView1"/> <OutputView name="MySampleView2"/> <OutputView name="MySampleView3"/> </OutputViews>
The post processing properties, valid only for outputStyle “Create Table”, “CreateMultipleTables” or “CreateMultipleViews”, have the following possible values:
- OutputComment — the output comment string to be used
- CollectStats (valid for “CreateTable”, “CreateMultipleTables”) — “true” or “false”
- CollectSample (valid for “CreateTable”, “CreateMultipleTables”) — “true” or “false”
- TrailingSql — the post processing SQL commands to execute