SystemProcs

Description

Specifies whether you want DataWindow Designer 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, DataWindow Designer 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

SYC Sybase Adaptive Server Enterprise

Syntax

SystemProcs = value

Parameter	Description
value	Specifies whether you want DataWindow Designer 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.

Parameter

Description

value

Specifies whether you want DataWindow Designer 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

Example 1

To specify that you want DataWindow Designer 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 tab in the Database Profile Setup dialog box.
Application To specify this statement in code, type the following:
```
SQLCA.DbParameter = "SystemProcs=0"
```