typed-correlation-clause

A typed-correlation-clause defines the appearance and contents of the table generated by a generic table function.

Syntax for typed-correlation-clause

Read syntax diagramSkip visual syntax diagramAScorrelation-name ( ,column-namedata-type )

data-type

Read syntax diagramSkip visual syntax diagramSMALLINTINTEGERINTBIGINTDECIMALDECNUMERIC(5,0)( integer, integer)FLOAT(53)( integer)REALDOUBLEDECFLOAT(34)(16)CHARACTERCHAR(1)( integer)CHARACTERCHARVARYINGVARCHAR( integer)GRAPHIC(1)( integer)VARGRAPHIC(integer)BINARY(1)( integer)BINARY VARYINGVARBINARY( integer)DATETIMETIMESTAMP(6)(integer)WITHOUT TIME ZONEWITH TIME ZONE

Description for typed-correlation-clause

typed-correlation-clause
The typed-correlation-clause defines the appearance and contents of the table that is generated by a generic table function. typed-correlation-clause must be specified when the table-function-reference is a generic table function and cannot be specified for any other table reference.

The maximum number of columns specified in the typed-correlation-clause is 750, an error is returned if the number of specified columns exceeds the limit.

An error is returned if duplicate column names are specified in a typed-correlation-clause.

An error is returned if the data type that is specified for a column name is not one of the supported data types for a generic table function.