DSXchange

Option 2 (Rebuild Repository Indices).
We exhausted all options and this one seem to work (Note: It COULD be that in the process of going through different options we might have fixed the issue, hard to say though.)

We had the same issue and IBM was not much help. However, running "DS.TOOLS" command seem to solve the problem.

Thank You !! I am running a sequence job which starts with extract (unix script) and if extract fails I want to change the job status to "failed". Right now, even if the extract fails, the job sends out email and job status is "finished". How do I make it fail when extract fails....

I am running a sequence job which starts with extract (unix script) and if extract fails I want to change the job status to "failed". Right now, even if the extract fails, the job sends out email and job status is "finished". How do I make it fail when extract fails.

Thanks,
-Sam

Thanks Arnd. Works like a charm.

Thanks to all who helped me resolve this issue.

-Sam

Arnd & Ken, I had to start a new topic (even though it is continuation of previous one) since the earlier topic was closed. But I ran into a problem when the start and end dates/time are different.. Here is the logic I followed.. Stage variables StartDate = ICONV(In.START_DATE[1,10],'D4-YMD') St...

Arnd, Followed through your steps (code): Converted date & time using Stage variables Added the derivation logic to the duration column; the only difference, I had to divide (EndTime-StartTime/60) to give me the result in minutes. Thanks for all your help...ditto Ken Have a great weekend!! -Sam

Arnd, Sorry, your message was not posted before I replied to Ken's answer. I am sure both work fine but your solution helps me in this case since I want to put the code in the transformer. I will try to implement and let you know. Again, thanks for the ultra-quick reply; Ken & Arnd. Sincerely, -...

Ken, Thanks for the quick reply... Do I create a routine with the below code... StartDate = LEFT(Arg1,10) StartTime = RIGHT(Arg1,8) FinishDate = Left(Arg2,10) FinishTime = RIGHT(Arg2,8) InternalStartDate = ICONV(StartDate,"D-YMD[4,2,2]") InternalStartTime = ICONV(StartTime,"MTS")...

I have 2 columns: START_DATE & END_DATE in the following format: 2005-12-02 18:40:00 (YYYY-MM-DD HH24:MM:SS) I have a column called DURATION which is a number(decimal) field and here is the rule: END_DATE - START_DATE in MINUTES So if a record has the following dates: START_DATE: 2005-12-02 18:4...

Thanks Craig. Works now...

Hello: I have a name column and all I want to do is if the first 2 characters in the name start with "SN", I need to strip the first 2 characters and load the name. I can say something like this... If LEN(link.NAME_COLUMN, 2) = "SN" Then ..???? not sure how to strip Else link.NAM...

Craig & Naveen, Thanks a lot. The solution worked like a charm.

-Sam

Looks like I might have got it...Please confirm... Also could you please tell me if its going to find all reversals in the string; REVERSAL, Reversal, & reversal in the UPCASE(count) function below... Thanks !! If (IsNull(INPUTLINK.COLA) = 0 AND Count(UPCASE(INPUTLINK.COLA),"REVERSAL")...

Chowdary, Thanks for the input. Could you please check the below syntax. Sorry for asking lame questions but I am new to DataStage. I want to check for NULL values. So, I want to add the below logic only if COLA is NOT NULL. How do I do it? Below logic is erroring for me. If IsNull(INPUTLINK.COLA) =...