New Stored Procedure Stage:
A new stored procedure stage allows users to easily use Oracle stored procedures
written in PL/SQL via OCI. The Stored Procedure Stage supports input and output
parameters making it easier to get information back from a stored procedure. It can
return a result set via output parameters and can return more than one row if the
procedure uses cursors. The stage can also execute a stored function and returns
status information from the procedure.
HTML Job Reporting from the Designer:
A detailed printable HTML format job report can be generated for the currently open joy or
shared container. The report can be produced using the new menu option in Designer: File ->
Generate Report. The final HTML report can be customized by applying different XSL style
sheets to the generated XML file.
Changes to File & Directory Browser Form:
The old style File & Directory browser form has been replaced with one modeled on the
standard Windows 2K browser. The new browser provides enhanced functionality on
directory navigation (tree-oriented) and file selection, it has filtering as well as saving and
restoring capabilities for the last viewed file list.
Ability to globally set Annotation properties:
The Annotation properties dialog is presented in the Tools -> Options dialog and the settings
are saved in the registry per user. The Annotation stage always defaults to the saved settings.
Ability to unset Environment Variables when a Job Runs ($UNSET):
A special value $UNSET was introduced where there is a need for a user defined
environment variable to explicitly unset the Unix environment variable to indicate false.
A dialog that provides information about what all the special environment variable values are
and what they are for is available by double-clicking at:
- Job properties dialog, Parameters tab, when editing the Default Value cell for a job
parameter defined as an environment variable.
- Admin Client, Environment dialog, when editing a value cell.
Transformer “Cancel” operation:
If the Cancel button or <ESC> key are pressed from the main Transformer dialog and
changes have been made, then a confirmation message box is displayed, to check that the user
wants to quit without saving the changes. If no changes have been made, no confirmation
message is displayed.
☻Page 102 of 210☻
The previously unsupported “Client Switcher” tool has been enhanced and integrated into the
DataStage Client. This tool allows the users to install and switch between multiple different
versions of the client. Switching between them also changes the desktop shortcuts and the
Start Menu group to point to another installed DataStage client.
Complex Flat File Stage:
A new Parallel Complex Flat File stage has been added to read or write files that contain
complex structures (for example groups, arrays, redefines, occurs depending on, etc.). Arrays
from complex source can be passed as-is or optionally flattened or normalized.
Parallel Job Runtime Message Handling:
When DataStage parallel jobs are run they can generate a large number of messages that are
logged and may be viewed in the Director Client.
Note: When the Local Run button is disabled, you cannot view log information from the
Director. Someone authorized to do so can enable the Local Run via the Apiary.
Message Handlers allow the user to customize the severity of individual messages and can be
applied at project of job level. Messages can be suppressed from the log (Information and
Warning messages only), promoted (from Information to Warning) or demoted (from
warning to Information). A message handler management tool (available from DS Manager
and Director) provides options to edit, add or delete message handlers. A new Director
option allows message handling to be enabled/disabled for the current job.
Visual Cues in Designer – Designer time job validation:
For parallel jobs (including parallel shared containers) and job sequences, errors that would
occur during compilation are optionally presented on the canvas without requiring the user to
explicitly compile the job. If there are potential problems with the stage that would cause a
compilation error, a warning triangle icon (Visual Cue) is shown on the top of the stage.
When the user hovers the mouse over a stage with the Visual Cue, a tool tip is displayed. The
Visual Cues can be turned off via a toolbar button (a ‘tick’ image).
Additional properties for Parallel Job Stages:
- File Name Column (optional) – add a column to the stage output that contains the name
of the file that the record is sourced from. Available on Sequential File and File Set
- Source Name Column (optional) – adds a column to the stage output that contains the
name of the source that the record is sourced from. Available on External Source Stage.
- Row Number Column (optional) – adds a column to the stage output that contains the
row number of the record. Available on Sequential File, File Set and External Source
- Read First Rows (optional) – constrains the stage to only read the specified number of
rows from each file. Available on Sequential File Stage.
- First Line is Column Names (mandatory) – on reading this tells the stage to ignore the
first line since it contains column names. On writing it causes the first line written to be
the column names. Available on Sequential File Stage.
☻Page 103 of 210☻
View Data functionality on the Source & Target custom stages:
- View data support was added to custom parallel stages for both source and targets.
- “Show file” had been replaced with “View Data” for Parallel Job, Sequential File and
File Set stages.
New Parallel Job Advanced Developer’s Guide:
A new Parallel Job Advanced Developer’s Guide gives DataStage Enterprise Edition users
information on efficient job design, stage usage, performance turning, and more. It also
documents all of the parallel environment variables available for use.