HomePowerBuilderAppeon Documentation Center

SystemProcs

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.

Applies to

ASE, SYC SAP Adaptive Server Enterprise

Syntax

SystemProcs=value

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 value

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:

    SQLCA.DBParm="SystemProcs=0"
Prev  Up  Next
SvrFailover  Home  TableCriteria