EVL

Table of Contents


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

Copyright © 2017–2020 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.

Writeora

(since EVL 2.2)

Write stdin or <f_in> into <table> in Oracle database. If the table is not empty, it is truncated unless ‘--append’ option is used. When delete statement need to be used instead of truncate, use option ‘--delete’.

Writeora

is to be used in EVS job structure definition file. <f_in> is either input file or flow name.

evl writeora

is intended for standalone usage, i.e. to be invoked from command line and reading records from standard input.

EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).

Important: Option ‘sep’ must be omited in EVD file as table it written by ‘$EVL_DEFAULT_FIELD_SEPARATOR’, which is by default ‘|’, and last field in each record is separated by ‘\n’.

Synopsis

Writeora
  <f_in> [<schema>.]<table> <evd> [-x|--text-input] [-a|--append | --delete]
  [-u|--username=<user>] [-p|--password=<password>]
  [--connect=<connect_identifier>] [--reject<n>=<f_out>]

evl writeora
  [<schema>.]<table> <evd> [-x|--text-input] [-a|--append | --delete]
  [-u|--username=<user>] [-p|--password=<password>]
  [--connect=<connect_identifier>] [--reject<n>=<f_out>]
  [--verbose]

evl writeora
  ( --help | --usage | --version )

Options

-a, --append

with this option data will be added to the table, otherwise overwrite it

--delete

with this option data will be deleted, not truncated

--reject=<f_out>

when reject() function is used in the mapping, input record is rejected into <f_out>

-x, --text-input

suppose the input 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

’sqlldr’ options:

--connect=<connect_identifier>

sqlldr 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 sqlldr

-p, --password=<password>

without this option environment variable ‘ORAPASS’ is used as password for sqlldr

-u, --username=<user>

without this option environment variable ‘ORAUSER’ is used as user for sqlldr