Readora
(since EVL 2.0)
Write to standard output or <f_out>
Oracle <table>
.
When <schema>
is not present, environment variable ‘ORADATABASE’ is used.
Password is taken from file ‘$EVL_PASSFILE’, which is by default ‘$HOME/.evlpass’. When such file has not permissions 600 (or 400), it is ignored! For details see ‘evl-password’.
- Readora
-
is to be used in EVS job structure definition file.
<f_out>
is either output file or flow name. - evl readora
-
is intended for standalone usage, i.e. to be invoked from command line and writing records to standard output.
EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).
- SQL*Plus Field Separator
-
Reading the table by SQL*Plus uses as field seprator the value of ‘$EVL_ORACLE_FIELD_SEPARATOR’, which is by default set to ‘\x1f’ (i.e. an Unit Separator), and last field in each record is separated by ‘\n’.
- SQL*Plus script hook
-
Custom options might be added to SQL*Plus script by environment variable ‘$EVL_ORACLE_SQLPLUS_HOOK’.
Synopsis
Readora [<schema>.]<table> <f_out> <evd> [-y|--text-output] [-u|--username=<oracle_user>] [--query=<query>] [-w|--where=<condition>] [ --connect=<connect_identifier> | --host=<hostname> [--port=<port>] ] evl readora [<schema>.]<table> <evd> [-y|--text-output] [-u|--username=<oracle_user>] [--query=<query>] [-w|--where=<condition>] [ --connect=<connect_identifier> | --host=<hostname> [--port=<port>] ] [-v|--verbose] evl readora ( --help | --usage | --version )
Options
- --query=<query>
-
use SQL
<query>
instead of reading whole table. With this option<table>
might be an empty string. - -w, --where=<condition>
-
use this where condition instead of reading whole table.
- -y, --text-output
-
write the output as text, not binary
Standard options:
- --help
-
print this help and exit
- --usage
-
print short usage information and exit
- -v, --verbose
-
print to stderr info/debug messages of the component
- --version
-
print version and exit
’sqlplus’ options:
- --connect=<connect_identifier>
-
sqlplus will be called in the form:
<username>/<password>@<connect_identifier>
where <connect_identifier> can be in the form
[<net_service_name> | [//]Host[:Port]/<service_name>]
without this option environment variable ‘ORACONN’ (if defined) is used as connection identifier for sqlplus
- -h, --host=<hostname>
-
either this or environment variable ‘ORAHOST’ should be provided when connecting to other host than localhost. If also ‘ORAHOST’ variable is set, this option has preference.
- -p, --port=<port>
-
either this or environment variable ‘ORAPORT’ should be provided when using other than standard port ‘1521’.
- -u, --username=<oracle_user>
-
without this option environment variable ‘ORAUSER’ is used as user for sqlplus