User`s guide
Customizing preferences
18 Sybase IQ ETL 4.1
• Create new project on startup — specify whether to automatically
start a new project each time you start Sybase IQ ETL. This option is
selected by default.
• Create new GRID projects — Not available.
• Create automatic link when components are added — specify whether
to create a link to an existing component is automatically when
dragging a new component onto an empty spot within the project
Design section. This option is selected by default.
• Display qualified transformation objects — specify whether the
names of projects and jobs in the Navigator section are displayed,
including the owner. This option is not selected by default.
• Use unique object name — specify whether to enforce unique project
and job names on a repository connection. This option is not selected
by default.
3 Select Query Designer and set the following options:
• Enable delete functionality of database objects — specify whether the
Truncate Object command on the right-click pop-up menu can be
selected to delete all records of a selected table. This option is not
selected by default.
• Default amount of records to retrieve from Query Designer — specify
the number of data records retrieved by the Query Designer. The
default is 25.
• Auto Join Generation — specify whether to automatically create joins
based on attribute names of the tables. This option is not selected by
default.
• Use brackets in join generation — specify whether to use brackets
when creating joins. This option is selected by default.
4 Select Engine and set the following options:
• Defaults to local engine operation — specify whether the UTL engine
starts when you start Sybase IQ ETL. This option is selected by
default.
• Engine Monitor update delay (sec) — specify the number of seconds
to wait between two updates of the Engine Monitor. The default is five
seconds.
5 Select Grid Engine and set the following options: