DBI Environment Variables

The following environment variables are defined for use with DBI:

  • DBI_DSN
  • The data source value to use if none is specified with the connect method.
  • DBI_DRIVER
  • The driver to use if none is specified with the connect method.
  • DBI_USER
  • The username to use if none is specified with the connect method.
  • DBI_PASS
  • The password to use if none is specified with the connect method. (For security purposes, this environment variable should not be set except for testing.)
  • DBI_TRACE
  • Enables tracing behavior as with the trace method. DBI_TRACE can be set to any of the following values:
    • Disables the trace
    • Traces the execution of the DBI
    • Outputs detailed call trace information including parameters and return values
  • filename
  • Appends trace information to the specified file; the trace level is set to .