These settings are only published in this appendix for reference purposes.
Do not change these settings without consulting a Teradata BI Repository expert or the Teradata Global Support Center.
| Key | Type | Default | Value |
|---|---|---|---|
| UseGroupingSets | DWORD | 2 | Specifies the setting for SQL grouping set usage. Valid values are: 0 – Disable grouping sets. 1 – Always use grouping sets. 2 – Grouping set support auto detection from Teradata Database. |
| UseNullIfZero | DWORD | 1 | Specifies the setting for controlling the use of NullIfZero in database-evaluated calculated measures involving division. When set to 1, the SQL expression wraps the denominator with NullIfZero. When set to 0, the SQL expression might fail if there is a division by 0 on Teradata Database. |
| UseQueryBands | DWORD | 2 | Specifies the setting for query band usage. Following are the valid values: 0 – Disable query bands. 1 – Always use query bands. 2 – Query band support auto detection from database. |