Stored Procedures Parameter Class Property Descriptions - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

Stored Procedures Parameter Class Property Descriptions

 

Table 39: Stored Procedures Parameters Class Property Descriptions 

Property Name

Description

CharType

Specifies the character set type of character fields

CommentString

The comment stored in Teradata for this parameter

DatabaseID

Teradata assigned identifier for the database where this stored procedure resides

ParameterID

Teradata assigned identifier for this stored procedure parameter

ParamLength

Contains the maximum length in bytes for the value of this parameter

ParamType

Contains the data type of this parameter

ProcedureID

Teradata assigned identifier for this stored Procedure

RowTypeDatabaseName

The name of the database containing the table referenced by a %ROWTYPE attribute

RowTypeTableName

The name of the table referenced by a %ROWTYPE attribute

SPParamType

Contains information on this parameter’s type:

I = IN
O = OUT
B = IN/OUT