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

Host to Server Assignment

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).