Calling Datastage Basic Routine Through Command Line

dstest · Post by **dstest** » Sun Oct 05, 2008 5:29 pm

I would like to know is there any way we can call datastage basic routine through DataStage Command Language.

Thanks

chulett · Post by **chulett** » Sun Oct 05, 2008 6:10 pm

Which? 'Command Line' impying from the O/S or 'DataStage Command Language'? If the latter, you'd need to explain what you mean by that - the TCL prompt?

dstest · Post by **dstest** » Sun Oct 05, 2008 6:25 pm

Using Datastage Command Language;

In unix when i execute dssh i am getting like below.

DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
DSEngine logged on: Sun Oct 5 15:56:53 2008

>

Here Can i call routine and get the output from routine.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 05, 2008 6:48 pm

No.

In the same way and for the same reason that you can't invoke a C function from the command line. There is no argument-passing mechanism from the command line.

Nor can you call DS routines from the TCL prompt. Your assertion that you can is wrong. If you disagree with that please provide an example.

You can only call "main" programs.

DS_SUPPORT · Post by **DS_SUPPORT** » Sun Oct 05, 2008 9:05 pm

You can create a dummy job and call the required routine, where you can pass the arguments as job parameters, and execute the job in command line. And set the output of the routine to UserStaus.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 05, 2008 9:15 pm

That hardly meets the requirement to "call routine through command line" though, does it?

You could write a main program too, if you knew how.

dstest · Post by **dstest** » Mon Oct 06, 2008 1:20 am

Thanks for your replies and suggestions.

DS_SUPPORT · Post by **DS_SUPPORT** » Mon Oct 06, 2008 7:39 am

Ray,

Can you Share some examples related to writing "main" program?

ray.wurlod · Post by **ray.wurlod** » Mon Oct 06, 2008 8:18 am

No, because it's not officially supported by DataStage. Even I don't use them (though I do know how, from my UniVerse expertise). If you must everything you need to know is in the DataStage BASIC manual, but you won't get any official support.