Calling Datastage Basic Routine in UNIX script

dstest · Post by **dstest** » Sun Jul 06, 2008 10:09 pm

Hi,

Is there any way we can execute Basic routine in unix script.

Thanks

ray.wurlod · Post by **ray.wurlod** » Sun Jul 06, 2008 11:44 pm

No. Like with other languages, routines lack a "main" module and therefore there is no command line interface, either from TCL or from the operating system.

You could construct a "main", or test bed, module, the same as the Test facility does on the fly, but there is no DataStage documentation on how this would be accomplished.

chulett · Post by **chulett** » Sun Jul 06, 2008 11:52 pm

I'm curious why you are asking... what are you trying to accomplish?

WoMaWil · Post by **WoMaWil** » Mon Jul 07, 2008 7:14 am

Generaly there is nothing in the world of IT what can not be done, if it is performing good or does make sense could be written on an other sheet of paper.

You can write a job with designer or a batch in Manager, who is calling your routine and is feeded by a parameter.

You than can write it into the log.

You can start this job then from the unix command line, wait til he is finish and then read the joblog with another command line command.

If you like it, do it.

kduke · Post by **kduke** » Mon Jul 07, 2008 12:19 pm

Ray is saying it can be done but it is not documented. Therefore probably not something IBM thinks you might need to do. I think Craig's question is still valid. Why?

chulett · Post by **chulett** » Mon Jul 07, 2008 12:25 pm

As do I.

Usually it's best to ask a more general 'how do I' question rather than focus on your perceived solution without giving us any clue about the problem you are trying to solve. We can usually get you on the right / much more better road to take you to your goal once we know what that is.

rameshrr3 · Post by **rameshrr3** » Mon Jul 07, 2008 2:37 pm

I have never encountered such a 'requirement' before.
Was that an 'interview question' by any chance?

Otherwise I'll second WomaWil's approach.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 07, 2008 2:58 pm

chulett wrote:We can usually get you on the right / much more better road to take you to your goal once we know what that is.

This may involve the MMB stage (an invention of Craig's).

chulett · Post by **chulett** » Mon Jul 07, 2008 3:12 pm

Maybe we can get it added to Quality Stage.