Programming in IBM® InfoSphere DataStage

These topics describe the programming tasks that you can perform in InfoSphere® DataStage® server jobs. Most of these use the BASIC language, which provides you with a powerful procedural programming tool.

There are several areas within a server job where you might want to enter some code:

• Defining custom routines to use as building blocks within other programming tasks. For example, you can define a routine which will then be reused by several custom transforms. You can view, edit, and create your own BASIC routines using the Designer client.
• Defining custom transforms. The function specified in a transform definition converts the data in a chosen column.
• Defining derivations, key expressions, and constraints while editing a Transformer stage.
• Defining before-stage and after-stage subroutines. These subroutines perform an action before or after a stage has processed data. These subroutines can be specified for Aggregator, Transformer, and some supplemental stages.
• Defining before-job and after-job subroutines. These subroutines perform an action before or after a job is run and are set as job properties.
• Defining job control routines. These subroutines can be used to control other jobs from within the current job.