Runora
(since EVL 2.0)
Run SQL from stdin or <f_in>
and write result into stdout or <f_out>
. It returns
output from ’sqlplus’ as is, so for quering the table to get formatted EVL output use
‘Readora’ or ‘evl readora’.
- Runora
-
is to be used in EVS job structure definition file.
<f_out>
is either output file or flow name. - evl runora
-
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).
Synopsis
Runora <f_in> <f_out> [-u|--username=<user>] [-p|--password=<password>] [--connect=<connect_identifier>] evl runora [-u|--username=<user>] [-p|--password=<password>] [--connect=<connect_identifier>] [-v|--verbose] evl runora ( --help | --usage | --version )
Options
Standard options:
- --help
-
print this help and exit
- --usage
-
print short usage information and exit
- --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