SystemProcs – PB Docs 126

SystemProcs database parameter

Description

Specifies whether you want PowerBuilder to display both system-stored procedures
and user-defined stored procedures in the connected database when you
request a list of stored procedures.

By default, PowerBuilder displays both system and user-defined
stored procedures in the connected database. If you set SystemProcs
to 0 or No, only user-defined stored procedures are displayed.

Controls

  • ASE, SYC SAP Adaptive
    Server Enterprise

Syntax

Parameter

Description

value

Specifies whether you want PowerBuilder to
display both system-stored procedures and user-defined stored procedures
in the connected database when you request a list of stored procedures. Values
are:

  • 0

    Display only user-defined stored procedures. You can also specify 'No' to
    set this value.

  • 1

    (Default) Display both system-stored procedures and user-defined
    stored procedures. You can also specify 'Yes' to
    set this value.

Default

SystemProcs=1

Usage

Setting SystemProcs to 0 or No speeds response time if you
want to work only with user-defined stored procedures.

Examples

To specify that you want PowerBuilder to display only
user-defined stored procedures in the connected database when you
request a list of stored procedures:

  • Database
    profile

    Clear the Display System Stored Procedures check box on the
    System page in the Database Profile Setup dialog box.

  • Application

    To specify this statement in code, type the
    following:


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