ExecDos Subroutine Not found

[srinagesh]

Hi

I have a windows batch file which has to be run after the ETL load completes. This is needed to refresh the Cognos Cube.

The Datastage is installed on Unix Box and I want to use the ExecDos subroutine in the "After-Stage Subroutine".

But I cant find ExecDos in the drop down.
I searched in the DS Managerm under Built-In> Before/After Sub routines, but couldnt find the file.

Is this subroutine available only when DS server is hosted on Windows ?

Is there any way in which I can call the Windows Batch file from my Datastage Job ?



Rgds
Nagesh

[guilbos]

You can probably have a program waiting for the presence of a file on the windows machine. That program would start the cube refresh. Your DataStage job would ftp a file to the windows server at the end of the execution.
It's not as easy as running directly from the server but it's possible.
Check the Cognos cube program maybe it can handle directly that kind of trigger.

Sylvain Guilbault

Hi

I have a windows batch file which has to be run after the ETL load completes. This is needed to refresh the Cognos Cube.

The Datastage is installed on Unix Box and I want to use the ExecDos subroutine in the "After-Stage Subroutine".

But I cant find ExecDos in the drop down.
I searched in the DS Managerm under Built-In> Before/After Sub routines, but couldnt find the file.

Is this subroutine available only when DS server is hosted on Windows ?

Is there any way in which I can call the Windows Batch file from my Datastage Job ?



Rgds
Nagesh

[ArndW]

The ExecDOS() will only work if your Server is installed on a Windows machine.

[kcbland]

Do you realize this is being discussed right now on another thread?

viewtopic.php?p=156165#156165

You might consider lightly reading the topics being discussed over the last few days, you might find problems you're currently experiencing as well as potentially seeing something that in the future, like tomorrow, may happen to you... :D

[ArndW]

Ken,

I thought the topic looked kinda familiar, I should have been paying more attention...

[srinagesh]

sorry guys.. didnt check that one..



Is it possible to share the source code for ExecDos..
I will make it as a Routine (with copy rights intact).. and run it..


Nagesh

[kcbland]

Is it possible to share the source code for ExecDos..

Huh??? You can't run DOS commands on a Unix server. You can see the source code, go look at it under the Routines folder in the DS Manager library.

It won't do you any good. You need to run something on a Windoze server from a Unix server your options for direct control are limited to the stated commands. You could setup a watcher (via FTP, rsh, or NFS mount solutions) on the Windoze machine to check for a file on the Unix box and then take action when found.

[shawn_ramsey]

Nagesh,

Does the company that you are working for use an enterprise scheduling tool (BMC Control-M, Embarcadero Job Scheduler, etc)? If so then architecturally this is where these types of inter application/server dependencies should be handled.

[ray.wurlod]

Beware, too, of case. It's ExecDOS, not ExecDos.

[srinagesh]

Thanx a lot guys..

I have taken up two solutions to the Top Management..

1. FTP a file to windows, which will be picked up by a batch job and start the cube refresh

2. Use Remote Shell


I guess the first option will be preferred.


Thanx a ton for all your replies.. they were really helpful in arriving at these alternatives.

Regards
Nagesh