Error running a batch file

chulett · Post by **chulett** » Thu Jun 21, 2007 2:37 pm

PATH issue, as in the directory where dsjob lives is not in your production PATH environment variable.

shyamrai · Post by **shyamrai** » Thu Jun 21, 2007 2:50 pm

chulett wrote:PATH issue, as in the directory where dsjob lives is not in your production PATH environment variable.

I have found dsjob.exe in the path D:\Program Files\Ascential\DataStage7.5 in Production.

I also found it present in the test.

Can I know what should I be checking other than this.

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jun 21, 2007 3:22 pm

You need to check that the DataStage bin directory's pathname is one of those in your command search list - that is, your PATH environment variable.
Temporarily you can include it.

Code: Select all

PATH=%PATH%;"D:\Program Files\Ascential\DataStage7.5\bin"

Ultimately you want to make the inclusion more permanent, either through Control Panel or through your login script.

shyamrai · Post by **shyamrai** » Fri Jun 22, 2007 7:33 am

I was able to define the path which was not present

Check for the Path in command prompt. If you donot find the path where dsjob.exe is present, goto My Computer ->Properties, Advanced Tab -> Environment Variables, look for PATH under Variable and add the path=D:\Program Files\Ascential\DataStage7.5 under value.

shyamrai · Post by **shyamrai** » Wed Jun 27, 2007 2:36 pm

But still I am getting the same error when I am scheduling it through TWS. But when I am directly executing the batch file, it is running the datastage job.
May I know how is it possible to make it permanent through Control Panel or login script.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 27, 2007 3:25 pm

Control Panel, System applet, Environment command button
PATH (maybe Path) is a System variable.

Select it and edit it to include the pathname of the DataStage Engine bin directory (and of the PXEngine bin directory if you have Enterprise edition).

Tip: copy the value of PATH out of the Variable value field into, say, Notepad, edit it there, then use copy/paste to put the new value into the Variable value field after visually checking your edit.

shyamrai · Post by **shyamrai** » Wed Jun 27, 2007 4:07 pm

[quote="ray.wurlod"]Control Panel, System applet, Environment command button
PATH (maybe Path) is a System variable.

Select it and edit it to include the pathname of the DataStage Engine [b]bin [/b]directory (and of the PXEngine [i]bin [/i]directory if you have Enterprise edition).

Tip: copy the value of PATH out of the Variable value field into, say, Notepad, edit it there, then use copy/paste to put the new value into the Variable value field after visually checking your edit.[/quote]

I have already added the pathname in PATH. But when I am running the TWS job, I am still getting the same error as I was getting before. Do I need to restart the server for this to work.

When I checked in the command prompt %path%, it gave a return as "''D:Ascential\DataStage\Engine\bin' is not recognized as aninternal or external command, operable program or batch file"

ArndW · Post by **ArndW** » Wed Jun 27, 2007 7:07 pm

shyamrai wrote:...it gave a return as "''D:Ascential\DataStage\Engine\bin'...

You are missing a "" in the 3rd position

ray.wurlod · Post by **ray.wurlod** » Wed Jun 27, 2007 8:24 pm

You are also missing a command. The bin folder contains the executables; it isn't one itself.

shyamrai · Post by **shyamrai** » Wed Jun 27, 2007 9:53 pm

[quote="ArndW"][quote="shyamrai]...it gave a return as "''D:Ascential\DataStage\Engine\bin'...[/quote]
You are missing a "" in the 3rd position[/quote]

I am sorry, it was actually set as 'D:\Ascential\DataStage\Engine\bin

shyamrai · Post by **shyamrai** » Wed Jun 27, 2007 9:55 pm

[quote="ray.wurlod"]You are also missing a command. The [i]bin [/i]folder contains the executables; it isn't one itself.[/quote]

Can I know what might be the command I am missing

chulett · Post by **chulett** » Wed Jun 27, 2007 10:30 pm

Please explain exactly what "When I checked in the command prompt %path%, it gave a return as" means. What you've shown is correct for a PATH statement as it is a collection of directories to search inside in the order listed for executables in the absence of an absolute path. It's nothing you can execute directly, which is what it appears you must have done to generate that error.

To answer the question as asked, you are 'missing' any valid command that lives in the mentioned 'bin' directory.

Isn't there someone on-site there with you that is a little more 'DOS savvy' and whom could help you with this?

ray.wurlod · Post by **ray.wurlod** » Thu Jun 28, 2007 3:49 am

The missing command is dsjob, based on your earlier posts.