PacketSize (ODBC)

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

Parameter	Description
value	A 32-bit integer value that specifies the network packet size in bytes

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

Example 1

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"
```