Numeric Value Assignment - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.