RPCRebind

Description

Specifies whether you want PocketBuilder to rebind Remote Procedure Call (RPC) parameters.

When to specify RPCRebind If your back-end DBMS supports the RPCRebind DBParm parameter, you must specify it before connecting to the database in PocketBuilder.

Applies to

ODBC

Syntax

RPCRebind = value

Parameter	Description
value	Specifies whether you want PocketBuilder to rebind RPC parameters. Values are: 0 (Default) Use the bound variable to determine all required binding information. 1 Rebind the parameters and use the parameter information returned from the database to bind the parameter.

Parameter

Description

value

Specifies whether you want PocketBuilder to rebind RPC parameters. Values are:

0 (Default) Use the bound variable to determine all required binding information.
1 Rebind the parameters and use the parameter information returned from the database to bind the parameter.

Default

RPCRebind = 0

Usage

For those DBMSs that support RPC calls, PocketBuilder binds the parameters for the call based on the size of the variables bound to the parameters.

Some drivers require rebinding of the parameters so that the parameter size (as returned from the back-end database) is used instead of the variable size. Failure to use the parameter size might result in an error or truncation for string parameters. However, some drivers always expect the binding to reflect the variable size. The RPCRebind parameter allows you to specify whether you want to rebind the parameters when RPCs are executed.

Examples

Example 1

To specify that PocketBuilder should rebind RPC parameters:

Database profile Select the RPC Rebind check box on the Transaction tab in the Database Profile Setup dialog box.
PocketBuilder application script Type the following in a PocketBuilder application script:
```
SQLCA.dbParm = "RPCRebind = 1"
```