DataStage Essentials
Designer Module
Server Edition
his document and the software described herein are the property of Ascential Software Corporation and its
licensors and contain confidential trade secrets. All rights to this publication are reserved. No part of this
document may be reproduced, transmitted, transcribed, stored in a retrieval system or translated into any
language, in any form or by any means, without prior permission from Ascential Software Corporation.
opyright © 2003 Ascential Software Corporation. All rights Reserved
scential Software Corporation reserves the right to make changes to this document and the software described
herein at any time and without notice. No warranty is expressed or implied other than any contained in the
terms and conditions of sale.
scential Software Corporation
0 Washington Street
estboro, MA 01581-1021 USA
hone: (508) 366-3888
ax: (508) 366-3669
scential, DataStage, INTEGRITY, MetaRecon, MetaStage and MetaBroker are trademarks of Ascential Software Corporation. Pick is
a registered trademark of Pick Systems. Ascential Software is not a licensee of Pick Systems. Other trademarks and registered
trademarks are the property of the respective trademark holder. 2
Module Objectives
Upon module completion, students will be able to:
• Customize the Designer’s layout and palette
• Create jobs and containers
• Create and use parameters within jobs
• Insert and link stages
• Use editing features for creating jobs and containers
• Set stage and job properties
• Load and save table definitions
• Save and compile jobs
• Run jobs from within the Designer
© 2003 Ascential Software Corporation. All rights reserved. 3
Logging In
The Designer Login Dialog Box
Enter the hostname or
IP address of the
server where
DataStage is installed
Enter your operating
system username and
password
Select the project to
attach to
© 2003 Ascential Software Corporation. All rights reserved. 4
Customizing the Layout
Standard
(resize or
anchor)
Canvas
(resize or
maximize)
Palette
(resize or
anchor)
Repository
(resize or
anchor)
Property
Browser
(resize or
anchor)
© 2003 Ascential Software Corporation. All rights reserved. 5
The Standard Toolbar
Save all Show/hide
open Job Compile annotations Help
jobs properties
Run Show/hide Print
Open Undo/redo grid canvas
Make Cut/ Copy/ Show / Zoom
new Paste hide link in/out
markers
Save Create Snap
current local/shared stages
job containers to grid
© 2003 Ascential Software Corporation. All rights reserved. 6
The Debug Toolbar
Edit breakpoints View job log
Select Step
job to through Stop Clear all
debug by link debug breakpoints
Begin Step through Toggle
debug by row breakpoint
Edit job Open debug
properties window
© 2003 Ascential Software Corporation. All rights reserved. 7
The Palette
Groups can be added,
deleted, or renamed,
and can be hidden
Multiple stages may
be available under
certain stage types
Stages can be shown
as small or large icons
and with or without
text labels
© 2003 Ascential Software Corporation. All rights reserved. 8
Customizing the Palette
Move
selected
folders up
and down
to reorder
categories
Click and
drag items
from left
panes to
folders in
right pane
Delete
selected
items
Repository items; All available stages; using
current view of all server and sequence delete key
available objects
© 2003 Ascential Software Corporation. All rights reserved. 9
The Repository and Property
Browser Windows
Current stage’s
Categories of Stage or link type — not present
objects in the name—can for links
current project’s be modified
repository—any of here or on Stage or link description—
them can be hidden the canvas directly modifies the
description field in the
stage or input/output link
© 2003 Ascential Software Corporation. All rights reserved. 10
Setting Program Options
Selected
categories that
can modify the
appearance or
functionality of
the Designer
Available options
to set for each
category
© 2003 Ascential Software Corporation. All rights reserved. 11
Creating New Jobs or Containers
© 2003 Ascential Software Corporation. All rights reserved. 12
Setting General Job Properties
© 2003 Ascential Software Corporation. All rights reserved. 13
Creating and Using Parameters
© 2003 Ascential Software Corporation. All rights reserved. 14
Inserting Job Control Language
© 2003 Ascential Software Corporation. All rights reserved. 15
Setting Performance Options
© 2003 Ascential Software Corporation. All rights reserved. 16
Inserting Stages
Click on
stage then
on canvas
or drag and
drop stage
on canvas
Click on
sizers to
resize stage
© 2003 Ascential Software Corporation. All rights reserved. 17
Linking Stages
Use link tool
to link
stages
together
Cursor
changes
when linking
stages
together
© 2003 Ascential Software Corporation. All rights reserved. 18
Setting Properties in Stages
Double click
stage or
right click
and select
Properties to
edit stage
properties
© 2003 Ascential Software Corporation. All rights reserved. 19
Inserting Metadata into Stages
Click in cells to
enter values or
select from
drop-down lists
Click Load
button to select
Table Definition
from repository
Import new
table definitions
on the fly, if
necessary
© 2003 Ascential Software Corporation. All rights reserved. 20
Saving Metadata in Stages
Enter values for
repository Table
Definition
Category
names
Click Save
button to save
current table
definition in
repository
© 2003 Ascential Software Corporation. All rights reserved. 21
Cut, Copy and Paste Features
Select items to copy
and Copy from Edit
menu, then Paste
into current or other
job or container
When items are
pasted, the stage
and link names are
updated to avoid
duplicate names
© 2003 Ascential Software Corporation. All rights reserved. 22
Saving Jobs and Containers
Job names are
case-sensitive
and must be
unique
Categories and
sub-categories
can be entered
manually by
separating them
with a backslash
(\)
© 2003 Ascential Software Corporation. All rights reserved. 23
Compiling Jobs
Messages from
compilation—this
is the desired
result!
© 2003 Ascential Software Corporation. All rights reserved. 24
Multiple Job Compile
Select job types
to compile
Only shows
uncompiled jobs Select jobs from
the job list and
‘Add’
© 2003 Ascential Software Corporation. All rights reserved. 25
Running Jobs within Designer
Click
Run
from
toolbar
Set any
job run
options
© 2003 Ascential Software Corporation. All rights reserved. 26
