ExecDos Subroutine Not found
Moderators: chulett, rschirm, roy
ExecDos Subroutine Not found
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
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
Re: ExecDos Subroutine Not found
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
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
srinagesh wrote: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
The ExecDOS() will only work if your Server is installed on a Windows machine.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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
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
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Ken,
I thought the topic looked kinda familiar, I should have been paying more attention...
I thought the topic looked kinda familiar, I should have been paying more attention...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.srinagesh wrote:Is it possible to share the source code for ExecDos..
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
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.
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.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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