UseProcSyntax
database parameter
Description
Specifies whether PowerBuilder should convert the syntax for
invoking a Remote Stored Procedure (RSP) or host-resident request before
executing that procedure.
Applies to
DIR SAP DirectConnect (applies only to Open ServerConnect)
Syntax
|
1 |
UseProcSyntax=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether PowerBuilder should convert RSP
|
Default value
UseProcSyntax=0
Usage
UseProcSyntax applies only if you are using Open ServerConnect to
make a gatewayless database connection to a DB2/MVS database. To
indicate that you want to use Open ServerConnect, select Gatewayless
from the Choose Gateway drop-down list on the Connection page. If you
select Gatewayless, and set the UseProcSyntax parameter to 1,
PowerBuilder converts the EXECUTE procedure syntax it normally uses to
the USE PROCEDURE syntax required to invoke RSP and host-resident
requests.
Examples
To specify that PowerBuilder should convert RSP or host-resident
syntax:
-
Database profile
Select the Use Procedure Syntax for RSPs check box on the
Syntax page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="UseProcSyntax=1;TRS=2"
See also