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.
Controls
-
ADO.NET
-
OLE DB
-
SNC SQL Native Client for Microsoft SQL Server
Syntax
|
1 |
PBMaxBlobSize=<span>value</span> |
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
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.DbParameter="PBMaxBlobSize=200000"