EVL – ETL Tool


Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Copyright © 2017–2022 EVL Tool, s.r.o.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Table of Contents

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