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 following the same rules as numeric assignment, except when DATEFORM=ANSIDATE is set.

The following types are valid:

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

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

    If a 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 of 10 are set to blanks.

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

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