Could someone give me a brief description of what a DS Routine is and when, why & where I might want to use one?
Thanks in advance.
DataStage Routines - What Are they?
Moderators: chulett, rschirm, roy
DataStage Routines - What Are they?
"The price of freedom is eternal vigilance."
-- Thomas Jefferson
-- Thomas Jefferson
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A DataStage parallel routine is an external function, written in C++, to perform any task that you like but which, for example, it is too tricky to achieve using regular Transformer stage expressions. One example is the ability to replace one substring with another anywhere in a main string, the so-called Ereplace() function.
Parallel Routines as viewed in the Repository are not routines at all, but rather metadata that record the existence, location, type and arguments of these external functions.
Parallel Routines as viewed in the Repository are not routines at all, but rather metadata that record the existence, location, type and arguments of these external functions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
And since we're in the General forum...
Server routines are written in DataStage BASIC and can be used in much the same manner as Ray noted but in the Transformer stage in a Server job. They also are what you can run 'Before' or 'After' jobs or stages and are what the Routine Activity stage in Sequence jobs run.
Like any routine, they can vary from the terminally simple to extremely complex. The 'job control' code I have in my toolkit (courtesy of Uncle Ken) is a thousand or more lines of routine code. Never bothered to count it all.![Wink :wink:](./images/smilies/icon_wink.gif)
Server routines are written in DataStage BASIC and can be used in much the same manner as Ray noted but in the Transformer stage in a Server job. They also are what you can run 'Before' or 'After' jobs or stages and are what the Routine Activity stage in Sequence jobs run.
Like any routine, they can vary from the terminally simple to extremely complex. The 'job control' code I have in my toolkit (courtesy of Uncle Ken) is a thousand or more lines of routine code. Never bothered to count it all.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Routines are separately-callable components - so the answer to your question is "yes". Manuals are the DataStage Programmer's Guide and the DataStage BASIC manual.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.