Purpose
Determines the data type returned by COUNT operations.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| 0 | Data type depends on session mode:
|
| 1 | Data type is NUMBER. |
| 2 | Data type is BIGINT. |
Default
0
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
If you experience numeric overflow errors with COUNT operations, try changing this field value to 1 or 2. This can happen for tables with billions of rows, specifically in Teradata session mode if the base table of the COUNT aggregate function exceeds about two billion rows.
Related Topics
For more information about aggregate functions including COUNT, see SQL Functions, Operators, Expressions, and Predicates.