DSXchange

I am trying to delete datasets using ORCHADMIN utility but running into issues. When I give orchadmin rm file.ds from $APT_ORCHHOME/bin, I get a message saying 'The environment variable APT_ORCHHOME cannot be empty'. Thie path is set in ENV variable for APT_ORCHHOME. Also, APT_CONFIG_FILE value is also set. Additionally I have set the PATH variable value to $APT_ORCHHOME/bin. But still I get the same mesage.

Any inputs?

Thanks

Could you output the result of "env | grep ORCH"?

The error message suggest that for the executing user APT_ORCHHOME is empty. As Arnd suggests, include an echo command in the script to verify whether or not this diagnosis is correct.

Ray and ArndW

I tried echo $APT_ORCHHOME and I do not get anything. I did ENV and see bunvh of variables but do not see APT_ORCHHOME. However the value is set when I check from ADMIN tool in ENV variables.

Thanks

Infact when I say echo $APT_ORCHHOME, I get a blank line as response.

Drop the "$" sign from the echo command.

did tou source the dsenv file before giving orchadmin command

Below is the output from echo command
echo APT_ORCHHOME
APT_ORCHHOME

Of course.

Dropping the dollar sign makes no sense (sorry Arnd) as that just echos back the string as typed. Some flavors of UNIX echo back an empty line when a value is not set, others specifically tell you it isn't set.

ROFL - how right you are, Craig - I was thinking of him assigning the value, not displaying. That's what I get for working 13 days solid

I was wondering. That's what you get for being a triskaidekaworkaholic.

You definitely don't want to use the $ when assigning the value.

It is not set in the current environment. So, one would need (as noted earlier) to 'source' their dsenv file first, if that is where those are set. If they are defined only in the Administrator, then they will be set when a job runs and accessible from the job's run-time environment, not all the time.

I tried this :

APT_ORCHHOME="D:\IBM\InformationServer\Server\PXEngine"
export APT_ORCHHOME

Now
echo $APT_ORCHHOME
D:\IBM\InformationServer\Server\PXEngine

cd bin
pwd
D:\IBM\InformationServer\Server\PXEngine\bin

orchadmin rm testfile.ds
orchadmin: not found

Not sure if there is any setting that needs to be changed.

I'm not able to find dsenv file on my machine. Is something new in version 8?

No, that's only applicable for a UNIX server, didn't realize you were running Windows. Ignore that bit of advice in your case.

What happens if you fully path your command?
Have you checked in your bin directory to confirm that command is (or isn't) actually there? Any chance it is "orchadmin.exe" on a Windows box? I neither know nor can check, hence the questions.

Craig,

Yes, it is orchadmin.exe in windows.

$ cd D:\IBM\InformationServer\Server\PXEngine\bin
$orchadmin.exe rm testfile.ds
orchadmin.exe : not found


If I try the same thing from windows prompt
D:\IBM\InformationServer\Server\PXEngine\bin>orchadmin.exe rm testfile.ds
The environment variable APT_ORCHHOME cannot be empty