Ray Wurlod

P.O. Box 1214

ABN 57 092 448 518

North Sydney  N.S.W.  2060

Education and Consulting Services

Australia

 

Email: rayw@mindless.com

 

 

Training: DataStage® BASIC Programming

 

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.

 

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.

 

Software

Training assumes version 7.5 or later of DataStage.

 

Duration

Four days, instructor-led.

 

Objectives

Having completed this training the student will be able:

  • to construct and validate DataStage BASIC expressions (using the Expression Editor where relevant):
    • to provide parameter or argument values in job sequences
    • to exert flow control decisions in job sequences
    • to implement custom triggers in job sequences
    • to constrain output links in BASIC Transformer stages
    • to derive output column values in BASIC Transformer stages
    • 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

 

Contents

          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® Websphere® DataStage.

IBM and WebSphere are registered trademarks of International Business Machines Corporation.

 

This page is copyright © 2006, 2007, Ray Wurlod. All rights reserved.

Page last updated 8 January 2007.