New and Expanded Functionality to aid DataStage users in job design and


• 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☻

• Multi-Client Manager:

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.

Enterprise Edition:

• 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.