Purpose
Determines whether native Teradata DATASET data type support is enabled in Teradata Database.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | DATASET support is enabled. Native Teradata DATASET data type has been or can be created and is available for use. |
| FALSE | DATASET support is disabled. |
Default
TRUE if no user-defined DATASET data type existed on the system at the time it was upgraded to Teradata Database 16.00.
FALSE if a user-defined DATASET data type existed on the system at the time it was upgraded to Teradata Database 16.00.
Changes Take Effect
After the next Teradata Database restart.
Usage Notes
The DIPDATASET DIP script creates the Teradata DATASET data type. If a system is being upgraded from a pre-16.00 release, and a user-defined data type named DATASET already exists on the system, the Teradata DATASET data type is not created, and the EnableDATASET field is set to FALSE.
If you want to use the Teradata DATASET data type on a system where EnableDATASET is set to FALSE, delete your DATASET data type, modify the value of EnableDATASET to TRUE, and run the DIPDATASET DIP script.
Related Topics
| For More Information on… | See… |
|---|---|
| DATASET data type | Teradata Vantage™ - DATASET Data Type, B035-1198. |
| Related DBS Control fields | DATASETAttributeSize, DisableDATASETValidation and EnableDATASETCSV. |
| DIP utility | Database Initialization Program (dip) |