Character String Assignment - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Preprocessor2
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
nyr1691484085721.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
xfi1470440464166
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.