DataStage BASIC Programming
Duration: Four Days
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