15.10 - Character String Assignment - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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.