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

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Period-as-Struct

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, DBS will return an error since the support of Period as Struct is an extension of the support of Structured UDTs.