ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

AppInfo connection parameter [APP]

Function 

To assist administrators in identifying the origin of particular client connections from a database server.

Usage 

Anywhere

Values 

String

Default 

Empty string

Description 

This connection parameter is sent to the database server from Embedded SQL, ODBC, or OLE DB clients. It is not available from Open Client or jConnect applications such as Interactive SQL or Sybase Central.

It consists of a generated string that holds information about the client process, such as the IP address of the client machine, the operating system it is running on, and so on. The string is associated in the database server with the connection, and you can retrieve it using the following statement:

select connection_property( 'appinfo' )

Clients can also specify their own string, which is appended to the generated string. The AppInfo property string is a sequence of semi-colon-delimited key=value pairs. The valid keys are as follows:

• API    Either DBLIB or ODBC.

• APPINFO    If you specified AppInfo in the connection string, the string entered.

• EXE    The name of the client executable (Windows and NetWare only)

• HOST    The host name of the client machine

• IP    The IP address of the client machine (UNIX and NetWare only)

• OS    The operating system name and version number (for example, Windows NT 4.0, NetWare 5.1)

• PID    The process ID of the client (Windows and UNIX only)

• THREAD    The thread ID of the client (Windows and UNIX only)

• TIMEZONEADJUSTMENT    the number of minutes that must be added to the Coordinated Universal Time (UTC) to display time local to the connection.

• VERSION    The version of the connection protocol in use, including major and minor values, and a build number (for example 9.0.00.3642)

If you specify a debug log file in your client connection parameters, the APPINFO string is added to the file.

Examples 

• Connect to the default database from the C++ version of Interactive SQL:

  dbisqlc -c uid=DBA;pwd=SQL

  View the application information:

  select connection_property('appinfo')

  The result is as follows (in a single string):

  HOST=machine-name;
  OS=Windows NT 4.0;
  PID=0x11b;
  THREAD=0x102;
  VERSION=9.0.00.3642

• Connect to the default database from the C++ version of Interactive SQL, appending your own information to the AppInfo property:

  dbisqlc -c "uid=DBA;pwd=SQL;app=ISQL connection"

  View the application information:

  select connection_property('appinfo')

  The result is as follows (in a single string):

  HOST=machine-name;
  OS=Windows NT 4.0;
  PID=0x10e;
  THREAD=0xe1;
  VERSION=9.0.00.3642;
  APPINFO=ISQL connection