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