16.20 - tdr.IsDimension - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Purpose

Checks whether a stream is a DIMENSION input stream.

Syntax

tdr.IsDimension(streamno)
streamno
Parameter type: integer

The input stream number.

Return Value

An integer indicating whether or not the input stream is a DIMENSION stream:
  • 1 if the stream is a DIMENSION stream
  • 0 if the stream is not a DIMENSION stream

Example: Check If a Stream is a DIMENSION Input Stream

stream <- 2;
X <- tdr.IsDimension(stream);

X is of type integer, and the value of X can be 0 or 1.