Ray Wurlod
|
|
|
ABN 57 092 448 518 |
North Sydney N.S.W.
2060 |
|
Education and Consulting Services |
|
|
|
Email: rayw@mindless.com |
DataStage BASIC is the programming language used in
job sequences and in server and parallel jobs (before/after subroutines and
BASIC Transformer stage). The ability to
construct expressions and routines in this language permits the developer to
exploit the full flexibility of these components of the DataStage product.
Routines written in this language can be called from server and parallel
jobs (as before/after subroutines), from server and parallel BASIC Transformer
stages (as transform functions), and from job sequence Routine activities.
Expressions written in this language are used extensively in server jobs
and in job sequences (version 7.5 and later).
This four-day class equips the attendee with the skills to create
expressions and routines in the DataStage BASIC programming language, including
the ability to interact with operating system files, hashed files and databases
from the language.
This class is intended for DataStage developers who create or maintain job
sequences, server jobs, transform functions or before/after subroutines.
Familiarity with using the DataStage client tools (Manager, Director and
Designer) is assumed. Familiarity with a
procedural programming language would be an advantage, but is not necessary.
Training assumes version 1.0 or later of DataStage. Those areas that are version specific, such
as some of the function calls in the API, are highlighted where they occur.
Four days, instructor-led, with extensive hands-on practice.
Having completed this training the student will be able:
·
to
construct and validate DataStage BASIC expressions (using the Expression Editor
where relevant):
o
to
provide parameter or argument values in job sequences
o
to exert
flow control decisions in job sequences
o
to
implement custom triggers in job sequences
o
to derive
user variables, parameter values and routine argument values in job sequences
o
to
constrain output links in BASIC Transformer stages
o
to derive
output column values in BASIC Transformer stages
o
to
initialize and derive BASIC Transformer stage variables
·
to
create, compile, test and troubleshoot routines that can be invoked from
expressions or from job sequences
·
to create
before/after subroutines that can be invoked from server jobs and their active
stages or from parallel jobs
1. Introduction to the Language
2. Expression Editor
3. Expression Elements
4. Character Strings
5. Dynamic Arrays
6. Dates and Times
7. Comparison and Boolean
Expressions
8. Routines: Programming Constructs
9. Transform Functions
10. Before/After Subroutines
11. Job Control Routines
12. Hashed File I/O
13. Sequential File I/O
14. Troubleshooting Techniques
15. DataStage API
16. BASIC SQL Client Interface
DataStage
is a registered trademark of International Business Machines Corporation.
Formally
the product name is IBM® Infosphere®
DataStage.
IBM
and InfoSphere are registered trademarks of
International Business Machines Corporation.
This page
is copyright © 2006-2010, Ray Wurlod. All rights reserved.
Page last
updated 09 February 2010.