15.10 - Numeric Value 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

Numeric values are converted as appropriate for the receiving field, provided the value can assume the requested format without losing leading digits.

The following types are valid:

  • DECIMAL
  • NUMERIC
  • FLOAT
  • REAL
  • DOUBLE PRECISION
  • BYTEINT
  • SMALLINT
  • INTEGER
  • The SQLCODE field in the SQLCA is set to -304 if the host variable cannot contain the returned data.