HomePowerBuilderAppeon Documentation Center

AppName

Description

If the DBMS supports it, specifies the application name you want to use when connecting to the database in PowerBuilder.

When to specify AppName

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

Applies to

ASE, SYC SAP Adaptive Server Enterprise

SNC SQL Native Client for Microsoft SQL Server

MSOLEDBSQL Microsoft OLE DB Driver for SQL Server

Syntax

AppName='application_name'

Default value

For Adaptive Server, PowerBuilder sets the CS_APPNAME connection property to PowerBuilder, as follows: 

AppName='PowerBuilder'

For SQL Server, there is no default value for AppName.

Usage

Adaptive Server databases

It is useful to specify a different AppName value for each of your Adaptive Server applications. If you are an administrator, you can query the MASTER.DBO.SYSPROCESSES table to determine which applications are running on the database server. The value specified for AppName displays in the program_name column of the MASTER.DBO.SYSPROCESSES table, making it easy to identify the applications.

Examples

Example 1

To set the application name to Test:

  • Database profile

    Type the following in the Application Name box on the Network or System page in the Database Profile Setup dialog box: 

    Test

  • Application

    Type the following in code:

    SQLCA.DBParm="AppName='Test'"

Example 2

You can set the AppName and Host parameters in a single statement to specify both the application name and the host name. To set the application name to Sales and the host name to Fran:

  • Database profile

    Type Sales in the Application Name box and Fran in the Workstation Name box on the Network page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="AppName='Sales',Host='Fran'"

See also

Host

(applies only to ASE and SYC SAP Adaptive Server Enterprise)

Prev  Up  Next
AppDriverName  Home  Async