EVL

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