User`s guide

Tools
6 Sybase IQ ETL 4.1
Tools
Structural and catalog information from all connected data sources is
accessible through Sybase IQ ETL Development tools, such as the Content
Explorer and the Query Designer. You can browse through schema
information, the data, or even create new database objects.
The Runtime Manager lets you create job schedules.
Unicode support
All components are designed to process and support virtually any
representation of data. Unicode-enabled transformation functions can be used
in calculations, scripts, and procedures.
Expressions
Square Bracket Notation (SBN) is a widely applicable indirection mechanism
within the Sybase IQ ETL environment. Square Bracket Notation can be
applied within expressions, SQL statements and filename specifications. Use
Square Bracket Notation to compute and assign values dynamically at runtime.
Internal database
Sybase IQ ETL technology includes a built-in, general purpose, relational
database to be used for temporary data storage and staging. It is based on
SQLite, a very fast, widely used, mostly SQL-92 compliant database. SQLite
is a small C library that implements a self-contained, embeddable, zero-
configuration SQL database engine.
The features include:
• Transactions are atomic, consistent, isolated, and durable (ACID) even
after system crashes and power failures.
• Zero configuration - no setup or administration needed.