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
PacketSize=value
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:
2048
-
Application
Type the following in code:
SQLCA.DBParm="PacketSize=2048"
