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.
Controls
-
DIR Sybase DirectConnect
(applies only to Open ServerConnect)
Syntax
|
1 |
UseProcSyntax=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether PowerBuilder should convert
|
Default
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
profileSelect 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.DbParameter="UseProcSyntax=1;TRS=2"