calling routine/job across proejcts
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
calling routine/job across proejcts
Hi,
Is it possible to call a routine and/or job that reside in project say 'common' from another project s say 'finance' , 'hr' etc.
I'd like to call them from a sequence(preferable) or a stub subroutine.
Thanks
Rati
Is it possible to call a routine and/or job that reside in project say 'common' from another project s say 'finance' , 'hr' etc.
I'd like to call them from a sequence(preferable) or a stub subroutine.
Thanks
Rati
Not sure about the routine, anything like a Routine Activity is going to be tied to the Project the Sequence is running in. However, jobs can be run 'cross project' if you leverage dsjob from the command line rather than using a Job Activity stage.
In other words, use an Execute Command stage and a 'wrapper' script for dsjob. That or a routine via a Routine Activity stage that uses DSExecute() to do the same.
In other words, use an Execute Command stage and a 'wrapper' script for dsjob. That or a routine via a Routine Activity stage that uses DSExecute() to do the same.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
Thank you Chulett. I am looking dir direct usage if possible, not via shell wrapper. I am thinking in terms a common project which would have the utility routines and the jobs. Any developer working in different projects should be able to reference them (not copy to their project) via some mechanism.
Would be nice, but no it doesn't work that way.
I do use the concept of a 'common project' for standard routines, the project where they are developed and tested but we still need to promote read-only copies to every project for people to be able to use them.
I do use the concept of a 'common project' for standard routines, the project where they are developed and tested but we still need to promote read-only copies to every project for people to be able to use them.
-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:
Can't see why not. A parallel routine definition (a pointer to the actual routine) would have to be set up in each project that needs to use it, but there need only be one actual routine.
Be very, very careful to undertake regression testing if you ever plan to change this routine, and add emphatic comments to the source code to explain that it is a shared routine!
Be very, very careful to undertake regression testing if you ever plan to change this routine, and add emphatic comments to the source code to explain that it is a shared routine!
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's also possible for server routines using global cataloging, but I don't want to go there. It's a maintenance nightmare.
Last edited by ray.wurlod on Wed Nov 19, 2008 1:50 pm, edited 1 time in total.
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.
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I've already said I'm not going there.
All the information you need is in the DataStage BASIC manual. Go ahead, build yourself and your successors a maintenance nightmare!
All the information you need is in the DataStage BASIC manual. Go ahead, build yourself and your successors a maintenance nightmare!
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.