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
UseProcSyntax=value
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether PowerBuilder should convert RSP or host-resident request syntax. Values are:
|
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:
SQLCA.DBParm="UseProcSyntax=1;TRS=2"
See also
