PBMaxTextSize

Description

Specifies the maximum length of text or large value datatypes returned when you include them in a report.

You can set the PBMaxTextSize parameter if you want to include a long text string in a report without treating the text as a binary large object (blob) datatype.

Applies to

SNC SQL Native Client for Microsoft SQL Server

Syntax

PBMaxTextSize='value'

Parameter	Description
value	The maximum length in bytes of text or large value datatypes returned when you include them in a report. The report can be created by a procedure. The range of valid values is from 10,000 bytes to 1,000,000 bytes.

Default

PBMaxTextSize=32767

Usage

The SQL Native Client OLE DB Provider for SQL Server automatically sets the SQL Server TEXTSIZE property to 2147483647 when connecting. The size of data fetched depends on the PBMaxTextSize parameter. If a result set includes a large value type, the blocking factor will be set to 1.

Examples

Example 1

To have SQL Server return text or large datatypes that are up to 48,000 bytes long when you include them in a report, type 48000 in the Maximum String Size in DataWindow® box on the Transaction page in the Database Profile Setup dialog box.