UseProcSyntax – PB Docs 126

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

Parameter

Description

value

Specifies whether PowerBuilder should convert
RSP or host-resident request syntax. Values are:

  • 0

    (Default) Do not convert syntax.

  • 1

    Convert syntax to USE PROCEDURE.

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
    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:

See Also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x