16.20 - FNC_TblOpSetDisplayLength - 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

Resets the lengths in column definitions for VARCHAR data types.

Syntax

void
FNC_TblOpSetDisplayLength(Stream_Direction_en    direction,
                          FNC_TblOpColumnDef_t *colDefs)
Stream_Direction_en direction
IN parameter
Stream_Direction_en is defined as follows:
typedef enum
{
   ISOUTPUT = 'W',
   ISINPUT = 'R'
} Stream_Direction_en;

Specify the input value ISINPUT for export and the value ISOUTPUT for import.

FNC_TblOpColumnDef_t *colDefs
IN/OUT parameter

A pointer to the column definitions which will be returned with the modified display lengths.

Usage Notes

This routine can be invoked for both import and export operations.

The routine is callable on a PE vproc only by a table operator.