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.
Applies to
ODBC (if ODBC 2.0 or higher driver and back-end DBMS support this
feature)
Syntax
|
1 |
PacketSize=value |
|
Parameter |
Description |
|---|---|
|
value |
A 32-bit integer value that specifies the network |
Default value
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.DBParm="PacketSize=2048"