DefaultProcOwner – PB Docs 2021

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.

Applies to

ADO.NET

ODBC

Syntax

Usage

The parameter can be set dynamically at runtime after connecting
to a database. You can also set it in your PBODB.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 PBODB.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 PBODB.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

PBMaxTextSize