PBMaxBlobSize

Description

Specifies the maximum blob size that PowerBuilder can read into memory.

When to specify PBMaxBlobSize You must specify a value for the PBMaxBlobSize parameter before connecting to the database.

Applies to

ADO.NET
OLE DB
SNC SQL Native Client for Microsoft SQL Server

Syntax

PBMaxBlobSize=value

Default

PBMaxBlobSize=1024000

Usage

PowerBuilder does not restrict the maximum blob size. Instead, the maximum blob size is determined by the machine on which the application is running. If the blob size exceeds the available memory on the machine on which the application is running, PowerBuilder reads the blob in chunks if the data provider supports the ISequentialStream interface. If the blob size exceeds the default value and the data provider does not support the ISequentialStream interface, PowerBuilder truncates it and reports an out-of-memory error. Use the PBMaxBlobSize parameter to specify larger maximum blob sizes.

Examples

Example 1

To set the PBMaxBlobSize value to 200000:

Database profile Type the following in the Maximum In-Memory Blob Size box on the Transaction page in the Database Profile Setup dialog box:
```
200000
```

Application Type the following in code:
```
SQLCA.DBParm="PBMaxBlobSize=200000"
```