Specifying table creation properties for a data mart report

The Table Creation properties are VLDB properties for data mart reports. These properties govern the parameters for the CREATE TABLE statement. The syntax of these statements is as follows (the SQL statement set is shown; table creation properties are indicated in italics):

CREATE <<Table Qualifier>> TABLE <<Table Descriptor>><<Table Prefix>>[TABLE NAME] <<Table Option>> ([COLUMN DEFN]) Table Space {PRIMARY INDEX/PARTITION KEY/PRIMARY KEY} Create Table Post String

Value options for ranking available as part of VLDB properties are as follows:

• 0: 6.x method

• 1: the analytical engine performs ranking calculations

• 2: ranking calculations are performed in the database

To set VLDB properties for data mart reports

1. If the Report Data Mart Setup dialog box is not displayed, open it. For steps to open it, see Data mart tools: Report Data Mart Setup dialog box.

2. Select the Advanced tab.

3. Enter the following property data:

   • Table Qualifier

   • Table Descriptor

   • Table Option

   • Table Space

   • Table Prefix

   • Create Table Post String

4. Click OK to return to the Report Editor.

Related Topics

• About data mart reports

• Creating and editing column aliases in data mart reports

• Deleting definitions from data mart reports

• Entering custom SQL statements for a data mart table

• Selecting a database instance for a data mart table

• Setting execution time limits for a data mart report

• Data mart editors

For additional information, see the Advanced Reporting Help.