Specifies whether PowerBuilder should convert the syntax for invoking a Remote Stored Procedure (RSP) or host-resident request before executing that procedure.
DIR Sybase DirectConnect (applies only to Open ServerConnect)
UseProcSyntax=value
Parameter |
Description |
|---|---|
value |
Specifies whether PowerBuilder should convert RSP or host-resident request syntax. Values are:
|
UseProcSyntax=0
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.
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"
