Job Sequneces(Execute Command)

[sowmyadevi]

Hi All,

I have created one batch file and saved in local disk. I am unable to execute this by using Execute Command, which is available in Job Sequences. It is not giving any error and the process of running is going on as infinite. How can i go about in order to pou-up the sqlplus window whenever i try to execute this batch file.

The batch file is as follows.

D:

CD ORACLE

CD ORA90

CD BIN

SQLPLUSW scott/tiger@oracle

please give your valuable ideas on this.

Thanks

[kcbland]

You cannot have a job open up dialog boxes or interactive GUI programs. DataStage jobs are compiled programs, mean to run in a non-interactive background executing mode.

If you insist on something like this, then do not use DataStage.