DefaultProcOwner database parameter
Description
The DefaultProcOwner parameter lets you set a default owner
for a stored procedure. The parameter takes effect only when the
stored procedure is not qualified. For ODBC, the PBNewSPInvocation
parameter must also be set.
Controls
-
ADO.NET
-
ODBC
Syntax
|
1 |
DefaultProcOwner='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
A string specifying the name of the default |
Usage
The parameter can be set dynamically at runtime after connecting
to a database. You can also set it in your PBODB126.INI file
if you want to create and retrieve data into a DataWindow with a
stored procedure data source in the DataWindow painter. The runtime setting
overrides the setting in PBODB126.INI.
You can also cancel the setting at runtime. If you do so, PowerBuilder uses
the current user as the owner of a non-qualified stored procedure
when it obtains the parameters of the stored procedure.
Examples
To set the default owner to proms in PBODB126.INI:
|
1 |
[SQL Anywhere] DefaultProcOwner='proms' |
In code:
|
1 |
SQLCA.DbParameter="DefaultProcOwner='proms'"; |
To cancel the setting:
|
1 |
SQLCA.DbParameter="DefaultProcOwner=''"; |
Note that the single quotes in the previous example contain
an empty string, not a space.