The DataStage® Basic Programming class is an instructor-led class designed to be delivered on-site, at your business location or a nearby training facility, in a training room equipped with one PC per student and connectivity to a DataStage server.
DataStage BASIC is the programming language used both in job sequences and in server jobs. 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.
Duration: Four days
Audience:
DataStage developers who create or maintain job sequences, server jobs or
routines. Familiarity with using the DataStage client tools (Manager,
Director and Designer) is assumed.
Objectives:
Having completed this training the student will be able to:
- construct and validate DataStage BASIC expressions (using the Expression Editor where relevant)
- provide parameter or argument values in job sequences
- exert flow control decisions in job sequences
- implement custom triggers in job sequences
- constrain output links in BASIC Transformer stages
- derive output column values in BASIC Transformer stages
- initialize and derive BASIC Transformer stage variables
- create, compile, test and troubleshoot routines that can be invoked from expressions or from job sequences
- create before/after subroutines that can be invoked from server jobs and their active stages
Contents:
- Introduction to the Language
- Expression Editor
- Expression Elements
- Character Strings
- Dynamic Arrays
- Dates and Times
- Comparison and Boolean Expressions
- Routines: Programming Constructs
- Transform Functions
- Before/After Subroutines
- Job Control Routines
- Hashed File I/O
- Sequential File I/O
- Troubleshooting Techniques
- DataStage API
- BASIC SQL Client Interface
DataStage is a registered trademark of International Business Machines Corporation.
IBM and the IBM logo are registered trademarks of International Business Machines Corporation.
