PacketSize (ODBC) database parameter
Description
Specifies the network packet size in bytes when you access
an ODBC data source in PowerBuilder.
Many back-end DBMSs either do not support
the PacketSize option or can return only the current network packet
size. For information about whether the DBMS you are accessing supports
PacketSize, see your DBMS documentation.
When to specify PacketSize
If your back-end DBMS supports it, you must specify the PacketSize parameter before connecting
to the database.
Controls
-
ODBC (if ODBC 2.0 or
higher driver and back-end DBMS support this feature)
Syntax
|
1 |
PacketSize=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
A 32-bit integer value that specifies |
Default
The default value for PacketSize is the default for your back-end
DBMS.
Usage
If the PacketSize value you specify is larger than the maximum
network packet size or smaller than the minimum network packet size,
your ODBC driver substitutes the maximum or minimum value for the
value you specified.
Examples
To set the network packet size for an ODBC data source
to 2048 bytes:
-
Database profile
Type the following in the Packet Size box on the Network page
in the Database Profile Setup dialog box:12048 -
Application
Type the following in code:
1SQLCA.DbParameter="PacketSize=2048"