EVL – ETL Tool

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–2021 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.

Writeqvd

(since EVL 2.2)

Write standard input or <f_in> into <file.qvd>.

Writeqvd

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

evl writeqvd

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).

Synopsis

syntax/Writeqvd
Writeqvd
  <f_in> <file.qvd> (<evd>|-d <inline_evd>)
  [-x|--text-input | -a|--text-input-dos-eol | -b|--text-input-mac-eol]
  [-s|--skip-bom] [-n|--null-as-string[=<string>]]

evl writeqvd
  <file.qvd> (<evd>|-d <inline_evd>)
  [-x|--text-input | -a|--text-input-dos-eol | -b|--text-input-mac-eol]
  [-s|--skip-bom] [-n|--null-as-string[=<string>]]
  [-v|--verbose]

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

Options

-d, --data-definition=<inline_evd>

either this option or the file <evd> must be presented. Example: ‘-d 'id int, name string, started timestamp'

-n, --null-as-string[=<string>]

write <string> instead of NULL value, without <string> specified it writes an empty string instead of NULL

--skip-bom

skip utf-8 BOM (Byte order mark) from the beginning of input, i.e. EF BB BF. Windows usually add it to files in UTF8 encoding

-x, --text-input

suppose the input as text, not binary

--text-input-dos-eol

suppose the input as text with CRLF as end of line

--text-input-mac-eol

suppose the input as text with CR as end of line

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