Period-as-Struct - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

Usage Notes

Period-as-Struct is a one byte ASCII field that indicates whether to treat Period data types as Structured UDTs in honoring the Transforms-off option and return information about the constituent attributes.

Language Variable Name
COBOL: PERIODASSTRUCT
C: periodAsStruct
Routine Action Taken
DBCHINI: writes
DBCHCL: reads (RSUP; IRQ)
Used by Action Taken
application program writes
Possible value that can be set in this DBCAREA field is 'Y' and 'N'.
  • 'N' - the value of 'N' indicates that Period data types are treated as simple data types.
  • 'Y' - the value of 'Y' indicates that Period data types are treated as Structured UDTs in honoring the Transforms-off option. Setting "periodAsStruct" to 'Y' requires setting the "transformsOff" to 'Y' at the same time. If not, the database will return an error since the support of Period as Struct is an extension of the support of Structured UDTs.