PBMaxBlobSize
database parameter
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
|
1 |
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:1200000 -
Application
Type the following in code:
1SQLCA.DBParm="PBMaxBlobSize=200000"