dbrep

NAME

SYNOPSIS

dbrep -l

dbrep [ -i oracle_sid ] [ -Y ] [ -n ] [ -r report ] [ -o option_list ]

AVAILABILITY

DESCRIPTION

The dbrep allows to run prepared SQL scripts with a simple interface against an Oracle database.

OPTIONS

-h

usage message.

-l

list all reports.

-i oracle_sid

Oracle instance (default is $ORACLE_SID).

-n

no report header output.

-Y

answer "execute alter report" question with yes.

-r report

report to generate (default is growth).

-o option_list

list of report parameters.

ENVIRONMENT

$ORACLE_SID

Oracle SID to connect ot by default.

EXIT STATUS

0

no error.

2

operating system not supported.

3

could not resolve an ORACLE_HOME.

4

usage printed.

5

command aborted.

6

configuration file etc/dbrep.cfg not found.

FILES

edrc/etc/dbrep.cfg

configuration file of dbrep.

edrc/etc/oratab

Oracle oratab file.

edrc/etc/tnsnames.ora

Oracle tnsnames.ora file.

edrc/var/log/dbrep.log

log file of dbrep.

edrc/lib/dbrep/reports/<report>.sql

prepared SQL script of the report/query.

edrc/lib/dbrep/reports/<report>.desc

prepared SQL script description- and option definition for the the report/query.

edrc/lib/dbrep/admin/<script>.sql

SQL scripts for admin/setup tasks needed in the Oracle database to be queried.

EXAMPLES

SEE ALSO

NOTES

BUGS

AUTHOR

COPYRIGHT

This is free software; see edrc/doc/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.