15.00 - Macro, UDF, SQL Stored Procedure, and External Routine Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Macro, UDF, SQL Stored Procedure, and External Routine Limits

 

Parameter

Value

Maximum number of parameters specified in a macro.

2,048

Maximum expanded text size for macros and views.

2 MB

Maximum number of open cursors per stored procedure.

15

Maximum number of result sets a stored procedure can return

15

Maximum number of columns returned by a dynamic result table function.

The valid range is from 1 to 2,048. There is no default.

2,048

Maximum number of dynamic SQL requests per stored procedure

15

Maximum length of a dynamic SQL request in a stored procedure

This includes its SQL text, the USING data (if any), and the CLIv2 parcel overhead.

Approximately 1 MB

Maximum combined size of the parameters for a stored procedure

1 MB for input parameters

64 KB for output (and input/output) parameters

Maximum size of condition names and UDF names specified in a stored procedure.

30 bytes, regardless of the DBS Control EnableEON setting.

Note: Other names specified in a stored procedure follow the EnableEON setting. See SQL Fundamentals for more information.

Maximum number of parameters specified in a UDF defined without dynamic UDT parameters.

128

Maximum number of parameters that can be defined for a constructor method for all types except ARRAY/VARRAY

128

Maximum number of parameters that can be defined for a constructor method of an ARRAY/VARRAY type

n

where n is the number of elements defined for the type

Maximum number of combined return values and local variables that can be declared in a single UDF.

Unlimited

Maximum number of combined external routine return values and local variables that can be instantiated at the same time per session.

1,000

Maximum combined size of the parameters defined for a UDF.

1 MB for input parameters

64 KB for output parameters

Maximum number of parameters specified in a UDF defined with dynamic UDT parameters.

The valid range is from 0 to 15. The default is 0.

1,144

Maximum number of parameters specified in a method.

128

Maximum number of parameters specified in an SQL stored procedure.

256

Maximum number of parameters specified in an external stored procedure written in C or C++.

256

Maximum number of parameters specified in an external stored procedure written in Java.

255

Maximum size of an ARRAY or VARRAY UDT.

This limit does not include the number of bytes used by the row header and the primary index of a table.

64 KB

Maximum length of external name string for an external routine.

An external routine is the portion of a UDF, external stored procedure, or method that is written in C, C++, or Java (only external stored procedures can be written in Java). This is the code that defines the semantics for the UDF, procedure, or method.

1,000 characters

Maximum package path length for an external routine.

256 characters

Maximum number of nested CALL statements in a stored procedure.

15

Maximum SQL text size in a stored procedure.

64 KB

Maximum number of Statement Areas per SQL stored procedure diagnostics area. See SQL Stored Procedures and Embedded SQL and SQL External Routine Programming.

1

Maximum number of Condition Areas per SQL stored procedure diagnostics area. See SQL Stored Procedures and Embedded SQL and SQL External Routine Programming.

16