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

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,…