StripParmNames

Description

Specifies that explicitly named parameters should not be passed to the ODBC driver.

Applies to

ODBC

Syntax

StripParmNames='value'

Parameter	Description
value	Specifies that explicitly named parameters should not be passed to the ODBC driver. Values are: Yes Remove all parameter names from the generated call escape syntax. No (Default) Keep parameter names that are explicitly specified and include them in the generated call escape syntax.

Parameter

Description

value

Specifies that explicitly named parameters should not be passed to the ODBC driver. Values are:

Yes Remove all parameter names from the generated call escape syntax.

No (Default) Keep parameter names that are explicitly specified and include them in the generated call escape syntax.

Default

StripParmNames='No'

Usage

By default, PowerBuilder retains parameter names if explicitly specified in the execution of a stored procedure. As a result, syntax such as the following might be generated and sent to the ODBC driver:

{call proc(a=?,b=?)}

Some database vendors do not allow parameter names to be specified in the generated call escape syntax. To prevent the passing of explicitly named parameters to the ODBC driver, set StripParmNames to Yes. This means that the parameters are passed in the order specified.

Examples

Example 1

To strip explicitly stated parameter names from a stored procedure:

Database profile Select the Strip Parameter Names check box on the Syntax page in the Database Profile Setup dialog box.

Application Type the following in code:
```
SQLCA.DBParm="StripParmNames='Yes'"
```