Character String Assignment - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

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

Character String Assignment

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.