StripParmNames database parameter
Description
Specifies that explicitly named parameters should not be passed
to the ODBC driver.
Controls
-
ODBC
Syntax
|
1 |
StripParmNames='<span>value'</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies that explicitly named parameters
|
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:
|
1 |
{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:
1SQLCA.DbParameter="StripParmNames='Yes'"