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:

0

Disables the trace

1

Traces the execution of the DBI

2

Outputs detailed call trace information including parameters and return values

filename

Appends trace information to the specified file; the trace level is set to 2 .

Get Perl in a Nutshell, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.