DSXchange

Please don't post the same question in multiple forums, it doesn't help you get an answer.

I've already responded in your other thread and ask that if anyone else would like to contribute that they please do it there.

What changed in the last three days? The answer is not 'nothing' or we wouldn't be here. An upgrade to your Siebel source, perhaps? Operating system patches? Something did and if it's not the job then you need to track down what else changed that is causing this problem. You should also take the err...

How can you solve it? By telling us whatever it is that you are not telling us that is causing this to fail. There is nothing wrong with the derivation posted and it does work when used properly as I've done this very thing in thousands of jobs over the years. You need to triple-check everything you...

Ah... never said your solution doesn't or wouldn't work for me, Ken. In fact I've filed it away for later use - nice technique with the bounding delimiters, btw. The thing is that I'd already built a routine that looked exactly like what Ray posted so I just ended up using that for this job and move...

Gosh, we need a new metric for Ray: g/w or Groaners Per Week. Yet another meaningless metric, much like rows per second, but what the heck...

Thanks guys. That turns out to be a poor choice of an example on my part, something cobbled together quickly without much thought as to how it might skew the answer. For single values I know I could have used Index. Truth is these aren't single values but unique 'value pairs' like 'UC', 'SL', etc. S...

Must not be firing on all cylinders today as this is eluding me at the moment. I have a constant defined in a stage variable that is a dynamic array. I need to compare an incoming field value to the content of that array and return the element number that corresponds to it. LOCATE works great for th...

Oracle, I would wager.

I need date format like this 03-DEC-2006 in OCI stage. Is it possible to change the date format inside the OCI STAGE like this ( To_date(Mycolumn DD-MON-YYYY). I am going to give this condition in USER DEFINED SQL. No, you don't "need" the date in that format. No, that's not what the TO_DATE needs ...

... until curiosity gets the better of you and forces you to click on the thread just to relieve the tension. Ah....

You might want to take a closer look at this thread unless you and Saama are on the same team. There is a button in the Designer that will generate an HTML document with all the metadata you could ever want... all you have to do is go in there one time and click it. After that, you don't even need t...

Perhaps !2B=is, eh?

ray.wurlod wrote:But, we argue, we answered the question that was asked.

Heck, I wasn't even trying to do that. Just picking on 2BOr!2B.

They're just 'regular' files associated with the RTI Input stages in the jobs. A 'file' command on H-PUX tells me that they are s500 assembler program text but cat'ing one out shows me the xml packets used when calling the service. Also interesting to note is that we have six 'always on' jobs runnin...

They most certainly are restartable with checkpointing enabled, we're doing that now. I can vouch for the fact that it will pick up from the failed job in the loop, just like it would for any other sequence of objects in a Sequence job. I cannot, however, confirm if the loop counter would be smart e...