User`s guide

Destination components
112 Sybase IQ ETL 4.1
Pre-processing SQL
This property provides one or more SQL statements to be executed during
initialization of the component.
Post-processing SQL
This property provides one or more SQL statements to be executed when all
components finished execution.
Opening Attribute Quote
The open quote (“x) character begins attribute names in SQL statements.
Closing Attribute Quote
The closing quote (x”) ends the attribute names in SQL statements.
Note If a record to be inserted violates any restrictions (for example:
constraints, referential integrity, unique index definition) of the underlying
table or object, an error message will occur. Rejected records are written to a
log file if you provide the reject log DB Options. When executing a project
from within a job the Continue on DB Write Errors option can be set to ignore
rejection errors.
See “Entering database connection parameters” on page 71 for more
information on the previous properties and the following properties:
• Database
• Schema
• Standardize Data Format
• Database Options
There is no impact on the simulation sequence.
View Projects in DemoRepository and Help Flash movie Demo Transfer
German Customers.