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.

Readqvd

(since EVL 2.3)

Write to standard output or <f_out> the content of the <file.qvd>. It parses fields as they are specified in EVD file, unless ‘--match-fields’ is specified.

Premium and Enterprise Edition

If there are less fields in the EVD file than in QVD, only such fields are returned. This functinality is not available for Trial and Standard Edition.

Readqvd

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

evl readqvd

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/Readqvd
Readqvd
  <file.qvd> <f_out> (<evd>|-d <inline_evd>)
  [-y|--text-output | -a|--text-output-dos-eol | -b|--text-output-mac-eol]
  [-m|--match-fields]
  [-n|--null-as-string[=<string>]]

evl readqvd
  <file.qvd> (<evd>|-d <inline_evd>)
  [-y|--text-output | -a|--text-output-dos-eol | -b|--text-output-mac-eol]
  [-m|--match-fields]
  [-n|--null-as-string[=<string>]]
  [-v|--verbose]

evl readqvd
  ( --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'

-m, --match-fields

match fields between EVD and QVD, otherwise they are taken one by one from input QVD file. If there are less fields in the EVD file than in QVD, only such fields are returned. This functinality is not available for Trial and Standard Edition.

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

read <string> as a NULL value, without <string> specified it reads an empty string as NULL

-y, --text-output

write the output as text, not binary

--text-output-dos-eol

produce the output as text with CRLF as end of line

--text-output-mac-eol

produce the output 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