Readora
(since EVL 2.0)
Write to standard output or <f_out>
Oracle <table>
.
- 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).
- Field separator
-
Option ‘sep’ must be omitted in EVD file as it is read by ‘$EVL_ORACLE_FIELD_SEPARATOR’, which is by default ‘\x07’, and last field in each record is separated by ‘\n’.
- Quoted strings
-
If at least one field in EVD file has option ‘quote="\""’
Synopsis
Readora [<schema>.]<table> <f_out> (<evd>|-d <inline_evd>) [-y|--text-output] [-u|--username=<user>] [-p|--password=<password>] [--connect=<connect_identifier>] [-q|--query=<query>] [-w|--where=<condition>] evl readora [<schema>.]<table> (<evd>|-d <inline_evd>) [-y|--text-output] [-u|--username=<user>] [-p|--password=<password>] [--connect=<connect_identifier>] [-q|--query=<query>] [-w|--where=<condition>] [--verbose] evl readora ( --help | --usage | --version )
Options
- -d, --data-definition=<inline_evd>
-
either this option or the file
<evd>
must be presented. Example: ‘-d 'id int, user_id string(6) enc=iso-8859-1'’ - -q, --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
- -p, --password=<password>
-
without this option environment variable ‘ORAPASS’ is used as password for sqlplus
- -u, --username=<user>
-
without this option environment variable ‘ORAUSER’ is used as user for sqlplus