routines

Tej · Post by **Tej** » Wed May 21, 2008 1:53 am

Hi,

am new to DataStage,

can any one help me in creation of routines,
what are the function used, how they can work...

Thanks in advance

ArndW · Post by **ArndW** » Wed May 21, 2008 2:16 am

Welcome to DSXChange, Tej.

The language used for programming routines is DS/BASIC, the language description can be read in the DataStage BASIC Reference Guide.

ray.wurlod · Post by **ray.wurlod** » Wed May 21, 2008 2:23 am

Routines are created in the DataStage repository (New -> Server Routine) and can either be transformation functions (executed for each row processed) or before/after subroutines (executed once per job). You can do whatever you like - whatever your coding skills permit, anyway - within routines, but per-row routines really should be short and snappy.