User`s guide

CHAPTER 5 Advanced Concepts and Tools
User’s Guide 51
Job execution state codes in the Task Scheduler are shown in the following
table.
Table 5-1: Job execution state codes
Customizing SQL and transformation rules
Setting up a project or job includes a variety of tasks, some of which can be
customized:
• Entering SQL queries to set up the source components
• Entering SQL commands for pre-processing and post-processing tasks
• Entering expressions, conditions, and procedures to manipulate the
transformation process
Although the format of the SQL commands is strongly dependent on the
database system that is connected to the component, the format of the
transformation language supported by Sybase IQ ETL (JavaScript) will not
change, no matter what source or target system you are using in your projects.
The JavaScript expressions can be included in Square Bracket Notations (SBN
expressions), which can considerably reduce your customization efforts. SBN
expressions can be part of component properties (if the
Evaluate property is
activated for the specific property), SQL statements, or any pre- or post
processing commands. An SBN expression resides inside an opening and a
closing square bracket and is evaluated at “Runtime,” as opposed to constant
expressions that are defined at “Design Time.”
Result Type Description
0 Info Job execution successful
1 Warning Job execution cancelled
101 Warning No valid license
10001 Error Unable to retrieve job data from repository
10002 Error Unable to find initialization component for job
10003 Error Unable to initialize external job settings
10004 Error Initialization failed
10005 Error Job execution failed
10101 Error Connect to repository database failed
10102 Error No valid repository found in connected database
10103 Error Unable to open session on connected repository