How to execute cognos transformer through DataStage ExecDOS

[dhwankim]

Hi All
Now I have tried to execute Cognos Transformer Command throuth DataStage ExecDos Routine.

the Command is below.
"C:\Program Files\Cognos\cer2\bin\trnsfrmr.exe" -n -s "D:\OLAP\Model\hlc-m-01.pyi"

When I ran this command using Windows Terminal Service.
It's Okay.

But When I tried to run the command in DataStage job wherein ExecDos

The Command is not working, just quit just after starting.

So I just want to workaround this progblem or any tips.

Thanks in advance.

[kduke]

Wrap this command in a batch file then execute the batch file. It may work better.

[ray.wurlod]

Hello DaeWhan,

Try the start command (or even the AT command).

Code: Select all

start "C:\Program Files\Cognos\cer2\bin\trnsfrmr.exe" -n -s "D:\OLAP\Model\hlc-m-01.pyi" 

You have indicated that this is a parallel job. Is this correct? I presume that you are running ExecDOS as an after-job subroutine.

[CLOPES]

Hello

Right command is :

start "cube name" /wait "repertory_to_trsf\trnsfrmr.exe" -nologo -dDataSourceDirectory=repertory_to_iqd_if_you_need_it -dCubeSaveDirectory=repertory_to_cube -n repertory_to_modelPYn\Incidents_hotlineUK.pyi

We have several Dos scripts and it works fine.