DSXchange

OK, was wondering about that. This isn't for a singleton file, I'm looking for a way to dynamically generate those filenames at the URL, much like a Folder would do with a local directory using a wildcard pattern. Is there some other way to pull that list of files at the HTTP URL and feed them into ...

Again, Toad is another environment using a different mechanism so that's not really "apples to apples". You need to check the explain plan while the job runs and see what it is actually doing and tune from there.

Can't check right now but there should be a "partitioned table" option of some kind in the stage. I believe it will attempt to automatically partition based on what it sees in the table and load the partitions in parallel.

I believe that would be a "zoned decimal" and from what little I recall you can tell it that in the CFF stage so it handles the overpunch correctly.

If you repeatedly view the exact same static data over and over using the same settings and the results are not identical, you need to report that to the vendor - i.e. your official support provider.

You really can't compare the two, not directly. What part of your job takes an hour - to start returning records? To process all records? If the latter, what's downstream of the OE stage?

That may very well be your path but it's not necessarily "the" path. FYI.

There is no such thing as an Oracle "bulk update". The "load" option in the OE stage is strictly for inserts, otherwise you're back to transactional sql. From that side of the equation there's also an Oracle merge aka "upsert" that you can look into but it's not the Hol...

I vaguely recall a nice post on this subject from Ernie some time back but sadly, could not turn it up.

Really? I did not know that.

It always helps to start out by explaining the "real situation". And you haven't modified the log message, just changed it a little bit, eh? Ok. So... there's nothing after the "error text is" part? :? No, that link won't help. Someone must have already done that if you can View ...

So which stage is giving you the issue - the ODBC stage or the DB2 stage? And please post the complete, unedited error from the log.

Time to mark this one as Resolved then and start yourself a new post for your 'new' problem.

First you'd have to provide enough information so people can actually help you. What database is this? What stage are you using to access it? What is the actual nature of the failure / the error text? All we know is it failed but with no clue as to why.

Thanks. I didn't have much luck but now wondering if that was I was still using a Folder stage to try and feed in the filenames found at the URL. Was that how your old job was setup?