15.10 - Date Assignment - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

Date values can be returned into any valid numeric host variable, according to the same rules that apply to numeric assignments, except when DATEFORM=ANSIDATE is set.

These types are valid:

  • DECIMAL
  • NUMERIC
  • FLOAT
  • REAL
  • DOUBLE PRECISION
  • INTEGER
  • Date values can also be returned into a character string variable.

    The host variable length depends on the DATE option set or defaulted. See “DATE(D|E|I|J|U) -d D|E|I|J|U” on page 71.

    If Teradata Database format is requested or defaulted, the receiving variable must be at least 8 bytes long. Surplus bytes are set to blanks. All other formats require at least 10 bytes. Bytes in excess are set to blanks.

    The SQLCODE in the SQLCA is set to -304 if the receiving field is too short.

    For ANSIDATE format, the receiving character variable must be at least 10 bytes long. Bytes in excess of 10 are set to blanks.