Calling a windows application

[DSguru2B]

Hi,
I am wondering that can I call a windows .exe or .bat from datastage installed on unix.
The process I am looking forward and brainstorming myself is that I want to run a VB macro to process a few files on windows server. Can this macro residing on windows be called from DataStage .
Or in easy words, can I windows application be called using datastage and then get its result to start processing those files after being ftp'd to unix.
I am sure there is a limitation to this, but I want to have some thoughts on this.
Thanks

[gateleys]

I have successfully run .vbs and .dll files created using VB.NET. Once they are created using Visual Studio or something, you need to register them using regsvr32 command in the DS server. Then, you can use the import external functions utility in the DS Manager. DS creates its own routine which makes a call to this external routine.

gateleys

[kcbland]

Google remsh, rlogin, rsh

All let you run commands on remote servers. DS jobs CANNOT start a graphical program, but can run straight DOS, perl, java, ksh, sh, and programs with stdin/stdout.

[DSguru2B]

Neat.
gateleys
How do we register it using the regsvr32, can you just guide me on that. The datstage server is in HPUX not on Windows server.

[DSguru2B]

Kenneth,
I am doing some research on it. Thanks for the head start.

[DSguru2B]

Kenneth,
Saying Datastage would not start graphical programs, does that mean it will not run a "".EXE".
What I mean by .exe is that if there is an executable made in VB as mentioned above, can that be triggered using DS?
The output of the .exe shall be processed .csv files used in ETL by datastage. So I am trying to stream line the process using Datastage, or this is a complex and troublesome approach.

[ray.wurlod]

I suspect gateleys is running DataStage on a Windows platform rather than a UNIX platform.

[angelloader]

regsvr32 is a command for registring COM objects (exe, dll, ocx,...).

usually you register COM objects like this :
regsvr32 myexe.exe
regsvr32 mydll.dll
regsvr32 myocx.ocx

COM , DCOM best applied in environments that are Windows-based.
But some UNIX implementations exists.

[gateleys]

Yeah DSGuru2B, my DS Server runs on Windows. Hence, I was able to register the windows file. I dunno how that might be possible with UNIX. I guess you will have to write your program in shell scripts or Java.

gateleys

[DSguru2B]

Running java,VB or any other scripting language would require a compiler to be existant on the Unix machine.
As per my research so far, I think its not possible to run .exe on unix machines.
Please correct me if I have the wrong assumption.
Any thoughts on this Ray?

[jhmckeever]

For what it's worth, on my current project we're connecting HP-UX and Windows using a pair of custom sockets applications (client and server) each written in C.

The client (running on HP-UX) is wrapped as a custom stage for DataStage use, and the server (which just sits awaiting a connection request) runs on Windows2000. The messages we're sending are in XML (both directions), but you could use any format you fancied.

HTH,

J.
[insert pithy sig here]

[jdmiceli]

Hi all!

Is there any possibility Mono would help here. Since it allows the running of .Net type stuff, could DS tie into that functionality to do what DSguru wants to do?

Bestest?