15.10 - Host to Server 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

Host variables can be used to pass column values to the server through the VALUES clause of the INSERT statement or the SET clause of the UPDATE statement.

PP2 does not perform any conversion before sending the data to the server, so the application must ensure that the host variable can pass the value to the server for conversion.

Assignment Rules

SQL Stored Procedures and Embedded SQL (B035‑1148) describes the rules for assigning Teradata Database variables.

Graphic Literals for Multibyte Characters

The precompiler recognizes GRAPHIC-type literals in the COBOLII language in the following form:

G’<###>’

 

Character

Description

G

The string is graphic data.

Single byte character.

<

Shift-Out meta character.

>

Shift-In meta character.

###

Quoted multibyte character string in a valid Kanji EBCDIC ideogram.

For more information on graphic literals (or constants), see SQL Data Types and Literals (B035‑1143).