DSXchange

HI Guys hope u all had a good thanksgiving, Here is what i have come up with for scheduling a job last friday of the month copy this into a file named test.txt: BEGIN { x=0 } { if(NF >=6) x=$6 } END {print x} This into a Script: lastfriday=`cal |awk -f test.txt` currdate=`date +"%e"` if [ ...

Thanks guys , I will have to start working on that routine as craig mentioned earlier.Yes My Crontab is not supporting the 6#3 .I got this by browsing google.
I will work on that routine and let you all know


Thanks
Rajesh

This entry should create a dummy file every third friday at 10:15 am.
But i am not sure of this part ? * 6#3 ,it doesn't like the # symbol or something.I got this code by browsing google unix forums.Please explain



Thanks
Raj

Guys, Finally i thoought of creating a file in unix and check for file every friday and this files will be only created on third friday and last friday with different names and chekinig these files my jobs will get triggered . I am doing this by altering my crontab file and creating these files. cod...

Can i do it with in a sequencer by using a wait for file activity or a execute command stage , but if i use the execute command then i should know when exactly is the last friday of the month from unix dynamically . and trigger the job every friday and the execute command should check wether its las...

i want to schedule a job every third and last friday of each month,we are only using datastage director to schedule jobs . Is there a way to run the jobs accordingly? Any ideas Please!


Thanks

Raj

chulett wrote:NO NEED TO SHOUT.

OK CRAIG

Thanks
Raj

Thanks RAY I CORRECTED IT AND NOW I CAN UNLOCK JOBS. SET-FILE and SETFILE are different commands. The "TO" is not part of the command, it is displayed as a prompt requiring further input. Execute the DS.TOOLS menu instead, and use the unlock facilities therein. This saves you fiddling with...

HI I HAVE JOB WHICH IS GOT LOCKED AND I WANT TO UNLOCK IT I FOLLOWED THE SAME PROCEDURE WHIC1) Login in into the Datastage server box from the command line as datastage adminstrator 2) goto Home directory i.e DSEngine directory 3) enter . ./dsenv 4) enter bin/uv or enter bin/dssh 5) LOGTO Project [p...

Hi Carter, Thanks a lot for your reply, Can you please help me out in this .I am desperatley looking for this solution,your response is highly appreciated. Thanks Raj. I agree that you should push back. But if you do have to create COMP-3, it's not really that bad (I've done it). Let us know. Carter

Hi, In my case i just need to give a feed to mainframes in a sequential file from our datawarehouse.So i need to convert this from a decimal to comp3 and give that value in a sequential file. Thanks Raj If you just pass the decimal into comp-3 field in the mainframe table, what error does it give?

Hi Guys,

Can anyone share their experience in this issue.



Thanks
Raj

Hi Guys, I have a requirement to convert decimal values to comp3 and send them to mainframes, i browsed through and couldnt find the solution any where there are previous topics on this but nothing got resolved in them , Can anyone please help me if they have done the same thing earlier it would me ...

Thanks a lot , It worked out for me , Basically i am using aggregator to do a group by after the result set but now i am doing it in the database itself so need of aggregator but i will continue investigating with the aggregator as craig mentioned. Thanks Raj In your query, if you add order by claus...

Thanks Kumar I Will try this out. In your query, if you add order by clause before the union operator then I think it will change the order of output. In DB2 at least it works like this. So a query (select * from emp where DeptNo=10 order by empno) UNION (select * from emp where DeptNo=20 order by e...