TABLE_UDF_ROW_BLOCK_SIZE_KB Option

Controls the size, in kilobytes, for server-allocated row blocks. Row blocks are used by Table UDFs and TPFs.

Allowed Values

0 to 4294967295

Default

128

Scope

DBA permissions are required to set this option. Temporary only for the PUBLIC group.

Description

Specifies the row block size, in kilobytes, to fetch from the server.

The server allocates row blocks when you use fetch_into to fetch rows from a table UDF, and when you use fetch_block to fetch rows from a TPF input table.

The row block contains as many rows as will fit into the specified size. If you specify a row block size smaller than the size required for a single row, the server allocates the size of one row.