User`s guide

Customizing SQL and transformation rules
58 Sybase IQ ETL 4.1
Starting the JavaScript Editor and Debugger
Within the Data Calculator JavaScript component, click Edit to open the
JavaScript Editor and Debugger.
The JavaScript Editor contains the following areas:
• Toolbar — consists of option buttons that you select to perform various
JavaScript Editor functions. Refer to the online help for details about the
toolbar.
• Object Navigator — consists of the Variables tab and the JavaScript tab.
The Variable tab consists of input and output port variables, as well as
temporary and pre-defined variables. From the JavaScript tab, you can
access all functions, commands, and system variables that can be applied
within the procedure.
• Edit/Debug — lets you edit the actual code. The area provides color-
coding of syntax structures.
• Monitor — consists of the following tabs:
• Tasks — contains the results of the validation after your procedure has
been compiled.
• Watch List — displays selected variables and their (changing) values
while stepping through the code during debugging.
• Input Records — displays the content of the current input record. To
synchronize Input and Output Record, click Simulate in the toolbar.
• Output Record — displays the content of the current output record.
• Expression — displays the result of the expression after you enter a
JavaScript expression and clicking the Evaluate button.
Edit and Debug mode
When launched, the JavaScript Editor and Debugger comes up in Edit mode.
To switch to Debug mode, you can:
• Select Start from the Debug menu.
• Click Compile.
A dark grey background of the edit area indicates Debug mode.To switch from
Debug mode to Edit mode, click Start Editing.
Editing and debugging JavaScript
A comment line starts with two forward slashes // at the beginning of the line.