Changing the Value for Date-form - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities
Date-form is initialized to the default value provided for Date-form in the site's HSHSPB. If the value is not appropriate for an application, the application may, before calling DBCHCL for Connect, change the values as follows:
  1. Set Change-options to ‘Y‘.
  2. Change the value for Date-form as follows:
    If... Then change the value for Date-form to...
    dates are stored using the default setting for the user (if such a default is associated with the user) or for the database D
    dates are stored in Teradata format T
    dates are stored in ANSI format A
  • T may always be specified, but A is rejected if the database does not support ANSI date formats.
  • Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.