BindSPInput

Description

Specifies that PowerBuilder bind input parameters in dynamic SQL statements when executing a stored procedure.

Applies to

Syntax

BindSPInput = value

Parameter

Description

value

Specifies whether you want to bind input parameters in dynamic SQL statements when executing stored procedures. Values are:

  • No (Default) PowerBuilder does not bind parameters in dynamic SQL statements when executing stored procedures.

  • Yes PowerBuilder binds parameters in dynamic SQL statements when executing stored procedures.

Default

BindSPInput = 'No'

Examples

Example 1

To specify that PowerBuilder should bind parameters in dynamic SQL statements when executing a stored procedure, type the following in a script:

SQLCA.DBParm = "BindSPInput = 'Yes'"

See also

DisableBind