Retrieving the Row - 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

Retrieving the Row

To retrieve the entire row, declare more than one host variable with the INSERT statement:

EXEC SQL INSERT INTO <table name> VALUES (...expressions) RETURNING
	:hostvariable1, 
	:hostvariable2,…