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
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
PBMaxBlobSize=value
Default value
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
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"
