HomePowerBuilderAppeon Documentation Center

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.


Default value

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

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'"
Prev  Up  Next
StrByCharset  Home  SvrFailover