User`s guide

CHAPTER 5 Advanced Concepts and Tools
User’s Guide 57
The following examples show pre-processing and post-processing SQL:
delete from products;
update customers
set cu_desc = 'valid';
Using the JavaScript Procedure Editor and Debugger
JavaScript is an object-oriented scripting language designed for embedding
into other products and applications. The language is divided into the core
JavaScript and client-side JavaScript. The client-side JavaScript is designed to
manipulate objects in Web browser, and the core language can be used in multi-
purpose environments.
Inside the Sybase IQ ETL Development environment, core JavaScript is
embedded to allow manipulation of objects to provide programmatic control
over them.
The core JavaScript functionality is enriched by grid functions, which enhance
the flexibility of the language. The JavaScript Editor and Debugger let you
interactively edit, debug, and execute JavaScript code.
Features
The JavaScript Editor and Debugger is mainly used (but not restricted) to set
up transformation rules on incoming data. Inside the JavaScript Editor and
Debugger, the scripts entered can be executed and tested using a single input
record.
The JavaScript Editor and Debugger offers the following features:
• Color-coded syntax for better readability
• Watchlist to control the assigned values of variables and attributes when
running or stepping through the code
• Multiple user-definable Breakpoints to stop code execution at any line
positions
• User-definable Go points to arbitrarily choose the position from which a
code shall be executed
• Step mode to execute the code line by line
• Step-over during debugging
• Evaluation of JavaScript expressions
• Verify the result of code execution