Character String Assignment - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Character string data is assigned to a host variable one character at a time.

Value Action Taken on Data
Shorter than the receiving field Blank filled
Longer than the receiving field
  1. Truncated
  2. SQLWARN1 in the SQLCA area is set to W

  3. The indicator variable, if present, is set to the length of the returned data
  4. In ANSI mode, SQLCODE is set to +902

  5. In ANSI mode, SQLSTATE is set to ‘01004’
The same length Moved with no exception conditions.