DSXchange

Bare bones, add something like this to your script: cd `cat /.dshome` && . ./dsenv And let us know if that helps. Hi Craig,, still its not working and here is the code I gave cd `cat /.dshome` && . ./dsenv echo "DATE and Time Is:" date echo "Hello" dsadmin -listp...

add "-mode NORMAL" to your command. Hi Arnd/Craig.. I didnt mean to ignore you... If you look at my previous post,, in my code I have included "-mode Normal" in my command.. but still then it did not return any value or error code.. Here is the command we used in the shell scrip...

It's your script, not the 'application engine' stuff I would wager. And you completely ignored this from Arnd: I would start with adding "-MODE NORMAL" to the command line. But how about printing out stderr in your script as well? dsjob -run -mode NORMAL -jobstatus -wait HCM89_EPM90DEV SE...

mikegohl wrote:No, I can not send you my code.

I mean to say syntax..

mikegohl wrote:Yes it did work. I called DSJOB directly from the Application Engine Program. I also used a run control table to store the parms, project and job name. The app engine parsed the parms and formatted the dsrun job command. I did not use a script.

Can you send me your code?

Thanks a lot!!

Yes it did work. I called DSJOB directly from the Application Engine Program. I also used a run control table to store the parms, project and job name. The app engine parsed the parms and formatted the dsrun job command. I did not use a script. Great!! Here is the code which I am using in the app e...

mikegohl wrote:I did this before. I created an Application Engine Program with a run control page.

Did it work for you?

I am doing the same thing..created an Application Engine Program with a run control page... but it doesn't work..

I am getting return value as 127

Post your actual script - that can't be it. 'Project Name'? 'Job Name'? we have added some debug statements in the script.. here is the modiefied program dsjob -run -jobstatus -wait HCM89_EPM90DEV SEQ_J_Stage_PS_ABS_CLASS_TBL RETURN_VALUE=$? echo "Return Value $RETURN_VALUE" we are gettin...

Hello, We are trying to trigger ETL job through PeopleSoft Process Scheduler and here is the situation: Datastage and PeopleSoft both are on UNIX box and they are on same box. here is the shell script code we gave and name of the shell script file is test.ksh: #!/bin/ksh echo "DATE and Time Is:...

Thanks Kenneth for your suggestions.3rd option looks simple to me .I will try that.

Thanks Craig.

HI , I have 3 jobs, they run once in a month. Here my question is , If new record is inserted in any one of source tables in any day after it ran and before they run again in next moth, that particular job need to be run on that day. Is there any way to get this through unix script or datastage jobs...

Thanks Ray for your suggestions.I will try it

HI Kenneth,

Thanks for your reply. I don't need running total, i need total hours of week1 and week2 for particulat employee and total hours of all employees in week1 as well as week2


Thanks
Sri

HI, I have source data like this Ubox empno week fri sat sun mon tue wed thu 134 111 1 2 3 3 0 0 0 0 134 111 2 1 2 1 1 2 3 4 134 222 1 1 2 5 1 4 5 6 134 222 2 4 3 4 5 6 7 8 I want the out pu tlike this Ubox empno week fri sat sun mon tue wed thu total gt 134 111 1 2 3 3 0 0 0 0 8 134 111 2 1 2 1 1 2...

Thanks throbinson.It worked perfect

Now I am able to open the directory.

Thanks