Page 1 of 2
ExecDos
Posted: Thu Nov 30, 2006 7:28 am
by Magesh_bala
Hi,
How to get ExecDos in job Before/After-Job routines, Presently i am not getting it in drop down.
Any help would be appreciated.
Posted: Thu Nov 30, 2006 7:38 am
by chulett
The only reason I'm aware of you wouldn't get it would be because your DataStage Server software is not installed on a Windows box. Do you get any kind of 'Exec' there? And which 'drop down' are you looking for it in?
Posted: Thu Nov 30, 2006 2:05 pm
by ray.wurlod
It might be that the indexing on DS_ROUTINES is not synchronized. Do you get ANY routines in the drop-down list? If so, which ones? Can you see ExecDOS in the Routines branch of the Repository? Go to the Administrator client, open the Command window, and execute the following query
Code: Select all
SELECT DSRID FROM DS_ROUTINES WHERE DSRID LIKE 'Exec%';
Let us know what you get.
Posted: Thu Nov 30, 2006 8:50 pm
by Magesh_bala
Except ExecDos i am getting all the Before/After sub-routines in job property, Even i cound't find it in DS_ROUTINES repository.
Posted: Thu Nov 30, 2006 9:45 pm
by ray.wurlod
Export it from another project (include read-only objects) and import it into this project.
Posted: Thu Nov 30, 2006 9:47 pm
by Magesh_bala
Hi,
I am not getting it in any projects. whether there is any option to enable it.
Posted: Thu Nov 30, 2006 9:50 pm
by chulett
Can you please confirm your DataStage server is actually installed on a Windows server? Are there any other 'Exec' routines in your drop-down? If so, please list them.
Posted: Thu Nov 30, 2006 9:58 pm
by Magesh_bala
Hi
Except ExecDos i am getting all the Before/After sub-routines in job property like DSsendmail DSjobreport DSWaitforfile execSH execSHSilent exec TCL.
Posted: Thu Nov 30, 2006 10:04 pm
by chulett
The fact that you get ExecSH (rather than ExecDOS) should mean your Server product is installed on a UNIX server unless I am sadly mistaken.
One last time - what platform is your server installed on? How hard is that question to answer? I'm afraid we are on what is known as a wild goose chase here...
Posted: Thu Nov 30, 2006 11:50 pm
by ray.wurlod
I have to agree with Craig. If the server is UNIX, you don't get ExecDOS or ExecDOSSilent.
You could clone ExecSH as ExecDOS, change all UNIX references to DOS, and it would be syntactically correct. However, attempting to use it on a UNIX machine is doomed to failure.
Posted: Fri Dec 01, 2006 6:58 am
by rameshrr3
Strange But True
I have DataStage installed on Solaris and i still get ExecDOS in before-After routines,and Of course ExecSH is there too.
However i dont get ExecDOSSilent. Is that a bug? EE Ver 7.51A.
Posted: Fri Dec 01, 2006 8:02 am
by chulett
Odd... my understanding has always been that you either get one or the other - which makes sense as your Server is installed on one or the other.
Can you check your ExecDOC routine and see if it is 'standard' or something new someone whipped up?
Posted: Fri Dec 01, 2006 10:48 am
by narasimha
Dont know if this is another addition to the odd list,
I have DS 7.0 Server edition installed on Windows XP, I see ExecSH in the list.
Posted: Fri Dec 01, 2006 11:26 am
by DSguru2B
Do you guys have mkstoolkit installed or a third party tool like samba that makes unix visible to windows and viceversa. That might have something to do with it
Posted: Fri Dec 01, 2006 12:02 pm
by chulett
Was wondering the same thing...