DSXchange Member Portal
Your Data Integration Community
DataStage BASIC

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