DefaultProcOwner – PB Docs 126

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

Parameter

Description

value

A string specifying the name of the default
owner of the stored procedure

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:

In code:

To cancel the setting:

Note that the single quotes in the previous example contain
an empty string, not a space.

See Also

PBNewSPInvocation


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x