Character String Assignment - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 17.20
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Preprocessor2
Release Number
17.20
Published
April 2023
ft:locale
en-US
ft:lastEdition
2023-04-21
dita:mapPath
neh1679404006646.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
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.