HostReqOwner

Description

Specifies the name of the host request library defined in a DB2/MVS database.

When to specify HostReqOwner

You must specify the HostReqOwner parameter before connecting to the database.

Applies to

DIR SAP DirectConnect (applies only to Access Service for DB2/MVS and Open ServerConnect)

Syntax

HostReqOwner='owner_id'

Default value

HostReqOwner='SAP'

Usage

The host request library is a special DB2 table that stores host-resident requests. A host-resident request is a SQL statement that a client application can execute as a procedure. If you do not use SAP as the owner name for this host request library, you should set the HostReqOwner parameter to an appropriate name for your site.

TRS Support

The HostReqOwner parameter is not applicable to DirectConnect TRS connections.

Examples

To set the name of your host request library to Stratus:

  • Database profile

    Type Stratus in the Host Request Lib Owner box on the System page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="HostReqOwner='Stratus'"

See also

TRS

UseProcSyntax