SystemProcs

Description

Specifies whether you want InfoMaker 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, InfoMaker 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 InfoMaker 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 InfoMaker 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 InfoMaker to display only user-defined stored procedures in the connected database when you request a list of stored procedures, clear the Display System Stored Procedures check box on the System tab in the Database Profile Setup dialog box.