Example: Retrieve a PERIOD(TIME) Datatype - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

This example uses the casting operator to retrieve a PERIOD(TIME) Datatype.

    01  RETURNFIELD          PIC X(40) VALUE SPACES.
    01  RETURNIND            PIC S9(2) COMP.

EXEC SQL
	SELECT PERIODT (CHARACTER(40))
        FROM TAB01
        INTO :RETURNFIELD :RETURNIND
        WHERE ID = 44
END-EXEC.