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
|
1 |
SystemProcs=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether you want PowerBuilder to
|
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
profileClear 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.DbParameter="SystemProcs=0"