15.00 - SHOW object - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

SHOW object

SHOW and Embedded SQL

SHOW is a data returning statement. It returns a single row of a single column whose data type is VARCHAR(20480), and which contains new line characters embedded in the character string.

In the workstation-attached environment, SHOW returns carriage return characters in the string, which locate the cursor to the first position of the current line.

SHOW... INTO cannot be performed as a dynamic statement. Dynamic execution of data returning statements always requires a dynamic cursor.