How to make .exe from exported jobs

scottr · Post by **scottr** » Mon Jan 24, 2005 4:52 pm

How to make .exe file with all job executables after exported in .dsx format.

thanks for help

chulett · Post by **chulett** » Mon Jan 24, 2005 4:55 pm

There is no ".exe" in the strictest sense for Server jobs.

What are you trying to accomplish?

scottr · Post by **scottr** » Mon Jan 24, 2005 5:04 pm

just i am checking is there any way we can make .exe file of DataStage project so that it can burn on CD and run this exe file on another system.

or inthe other way combining all jobs,routines,tabledefinations etc.. into .exe file.(like MS VisualBasic ).

also pl let me know is there any way to install the entire project on another system.(apart from exporting .dsx format)

and if we export project using .dsx do we need to set all parameters like connection strings,file path names etc..

thanks.

T42 · Post by **T42** » Mon Jan 24, 2005 6:47 pm

Sorry buddy. You must have a licensed copy of DataStage on every server you want to run the job on.

That's how Ascential make money.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 24, 2005 8:07 pm

A DataStage export is created on the client machine.

You don't need to move it to be able to import what was exported into another project on another host.

All you have to do is to connect to the other host (which must, of course, have DataStage (legally) installed). In the common connection dialog for DataStage clients, the top field is host name. You can type in the name, or IP address, of the DataStage server machine to which you want to connect.

The only way to "install" a project is to create one using the DataStage Administrator. Technically you can copy one to the new location, but you'd spend so long correcting all the system table entries that describe it (remember that a DataStage project is a database in its own right) that it would be much faster to export, create new project and import.