AppInfo connection parameter [App]

To help administrators identify the origin of particular client connections from a database server.

Anywhere

Empty string

This connection parameter is sent to the database server from Embedded SQL, ODBC, or OLE DB clients, as well as Interactive SQL (Classic on Windows and DBISQLC on UNIX). It is not available from Open Client or jConnect applications such as the Java version of Interactive SQL (DBISQL) or Sybase Central.

The AppInfo connection parameter generates a 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:

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

• 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=Sun_Solaris 2.8;
  PID=0x11b;
  THREAD=0x102;
  VERSION=7.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=Sun_Solaris 2.8;
  PID=0x10e;
  THREAD=0xe1;
  VERSION=7.0.00.3642;
  APPINFO=ISQL connection