ExecDos

Magesh_bala · Post by **Magesh_bala** » Thu Nov 30, 2006 7:28 am

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.

chulett · Post by **chulett** » Thu Nov 30, 2006 7:38 am

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?

ray.wurlod · Post by **ray.wurlod** » Thu Nov 30, 2006 2:05 pm

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.

Magesh_bala · Post by **Magesh_bala** » Thu Nov 30, 2006 8:50 pm

Except ExecDos i am getting all the Before/After sub-routines in job property, Even i cound't find it in DS_ROUTINES repository.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 30, 2006 9:45 pm

Export it from another project (include read-only objects) and import it into this project.

Magesh_bala · Post by **Magesh_bala** » Thu Nov 30, 2006 9:47 pm

Hi,

I am not getting it in any projects. whether there is any option to enable it.

chulett · Post by **chulett** » Thu Nov 30, 2006 9:50 pm

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.

Magesh_bala · Post by **Magesh_bala** » Thu Nov 30, 2006 9:58 pm

Hi

Except ExecDos i am getting all the Before/After sub-routines in job property like DSsendmail DSjobreport DSWaitforfile execSH execSHSilent exec TCL.

chulett · Post by **chulett** » Thu Nov 30, 2006 10:04 pm

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...

ray.wurlod · Post by **ray.wurlod** » Thu Nov 30, 2006 11:50 pm

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.

rameshrr3 · Post by **rameshrr3** » Fri Dec 01, 2006 6:58 am

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.

chulett · Post by **chulett** » Fri Dec 01, 2006 8:02 am

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?

narasimha · Post by **narasimha** » Fri Dec 01, 2006 10:48 am

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.

DSguru2B · Post by **DSguru2B** » Fri Dec 01, 2006 11:26 am

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

chulett · Post by **chulett** » Fri Dec 01, 2006 12:02 pm

Was wondering the same thing...