Customizing SQL and Transformation Rules

When setting up an ETL project or job, you can customize SQL queries for setting up source components, SQL commands for processing tasks, Expressions, conditions, and procedures to manipulate the transformation process.

• Expressions and Procedures
  An expression is a combination of identifiers and operators that can calculate a single value. A simple expression can be a variable, a constant, or a scalar function. You can use operators to join two or more simple expressions into a complex expression.
• Variables
  A variable is a symbolic name for a value.
• Functions
  Sybase IQ InfoPrimer includes a complete set of functions and operators that supports Unicode character sets.
• Square Bracket Notation
  Most component properties can contain SBN expressions that are evaluated before being used by the IQ InfoPrimer Server on project configuration, simulation, or execution. An SBN expression is a JavaScript expression surrounded by square brackets [..]. You can use multiple SBN expressions within a single string value.
• Working with SQL Properties
  Nearly all components with database connectivity support custom SQL statements executed in different phases of the transformation. There are two basic types of SQL properties, queries and scripts.
• SBN Expressions
  You can use SBN expressions in SQL properties. Although the specified example is a query, the technique applies to both types.
• JavaScript Editor and Debugger
  JavaScript is an object-oriented scripting language designed that is embedded into other products and applications. JavaScript allows manipulation of objects to provide programmatic control over them.