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

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.

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:

  PowerBuilder

  Test

  1

  Test

• Application

  Type the following in code:

  PowerBuilder

  SQLCA.DbParameter="AppName='Test'"

  1	SQLCA.DbParameter="AppName='Test'"

Example 2

(Does not apply to DirectConnect) 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:

  PowerBuilder

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

  1	SQLCA.DbParameter="AppName='Sales',Host='Fran'"