DSXchange

LOL!!!

It is frowned upon to string unrelated questions together. Please don't make it a habit. I'm sure there's an "expansion" for "RT" & "BP" but you'd need one of the Grognards to chime in, someone who'd been in on the development of the product. I'd just be guessing. To me, all that really matters ...

Whatever you 'clear' from the log is gone, so no.

No laughing here, just a learning opportunity. Sometimes it's hard to tell if something is wrong or right when someone says "I have something like this" in a job, your first inkling is to give them the benefit of the doubt and assume they've really got it correct. However, if we dig deeper and thing...

But then I have a simple statement like if PreviousValue <> CurrentValue then myCounter = myCounter +1 else myCounter How 'like' that is it? Your syntax as posted is invalid if that's literally what you have in the derivation. It should be: if PreviousValue <> CurrentValue then myCounter+1 else myC...

Add to Schedule over and over, at 30 minute intervals... and hope it never takes more than 30 minutes to run.

The DS.TOOLS menu. Search the forums for discussions on its use.

:D He wasn't offering to build one for you, just stating his preference as to the approach to take to solve this.

Set it to something you know won't ever match on the first comparison, say "?" for example. None means null so your <> check always fails.

What do you have for the Initial Value of the counter and previousvalue stage variables? Hopefully something valid for the datatype and not just null/empty.

Search again, this had been discussed a bajillion... well, a lot.

Try searching for a significant portion of your message that doesn't include anything specific to you, like "Controller problem: Unhandled failure" - that should turn up quite a number of conversations.

But my previous and current columns are identifical when i view them in the next stage Of course, because your last stage variable derivation makes them the same and rightly so: currentvalue ----------------------------------> previousvalue Nothing looks obviously wrong to me, what output are you a...

Is this actually what's in your dsenv file?

RACLE_HOME=/home/oracle/ora9204; export ORACLE_HOME

ORACLE without the 'O'?

Not sure, you'd need to either ask Support or just try it when you can and let us know.

Typically this happens when you think they are identical when in fact they are not. You need to triple-check, very carefully. They would need to match exactly: case, length, character for character - the whole nine yards. Length isn't enforced in Server until it hits a database, so just because you'...