Page 1 of 1
routines
Posted: Wed May 21, 2008 1:53 am
by Tej
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
Posted: Wed May 21, 2008 2:16 am
by ArndW
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.
Posted: Wed May 21, 2008 2:23 am
by ray.wurlod
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.