DSXchange

What craig is telling to do is disable both the options 1)Automatically Handle Activities that fail 2)Log warnings with activities that finish other than OK in your job properties, if you have enabled check point restartabilty. Your routine is returning a value which is other than ok (date in your c...

You have an option to with the "Search Options" to restrict the search based on the time period.

. I dont have a clue about how to do that. Please enlighten me.

Hi all, just to know, is there anyway to search by date, lets say I want to get the posts from Jan1st to see the current posts. How to search for that? Why I am asking is if yesterday I have logged in to DSXchange and if I have like 50 new posts since my previous login, and if I couldnt go thru all ...

Hi DSGuru congrats on your 3k. Whenever I am in DSXchange, I cannot help but think of you guys like how much time you guys(U,ray,craig,narsimha,kim etc) spent daily replying the posts. Any ball park estimate?

I am sorry. Might have overlooked something.

See if this helps
OConv("IConv("DATE",D-DMY)",D-YMD)
where date is the date value you pass.

Strange. My suggestion would be to test the job in QA environment pointing to dev databases and see what happens. Will be glad if that helps.

Thanks craig. In that case, just a thought, may be this is a windows XP sp2 issue. The sequences behave wierdly till the patch is installed. Name of the patch is dsclient_xpsp2. Your admin sholud be able to help.

Pls Correct me if I am wrong. Till now I assumed 7.5.2 is same as 7.5x2.
Is it not?

Looks strange. But the best bet is to drag the job (that you want to add to the sequence) from the repository into the canvas and then edit the job properties. Even we are using 7.5.2 and I dindt have any problems.

I may not understand 100% about your design but what I understand is your sequence starts with D then followed by A,B,C,E. If any of a,b,c is aborted, you want to start again from A. If thats true, then my suggestion is wrap A,B,C in a child sequence say Z. So your main sequence looks like D--->Z---...

Are you saying the data is shuffled or the column order changed? If the data is shuffled, then it is totally expectable cause the data is distributed randomly among the number of nodes your datastage is using and then collected back at the output. If the column order is changed, then you have check ...

We used Routines to read the variables from parameter files, call them before the job actvities in the sequence when we are using Datastage 6. I guess thats the only option.

Yes craig its DB2. This is the first time using DB2. So I posted if any DB2 guys knows the syntax. Thanks for reply.

Hi all, I have a DB2 stage. The query previously looks like below. select all from a, b where a.xrlinkdt between current date - 2 month and current date . The job is runnig fine Now when I changed the query to select all from a, b where a.xrlinkdt >=TO_DATE('2007-01-01', 'YYYY-MM-DD') and a.xrlinkdt...