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.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
Syntax
|
1 |
SystemProcs=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether you want PowerBuilder to display
|
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:
1SQLCA.DBParm="SystemProcs=0"