DSXchange

From what I recall, the DRS stage uses the ? parameter markers, not the numbered ones - they are exclusive to OCI.

Define exactly what you mean by 'batches', just to ensure it means the same thing we may think it means. Otherwise, you can get a generic answer, which is - there is an option in the Director to create / maintain "Batch::<YourName>" jobs. Which are equivalent to coding directly in the Job Control ta...

Crybaby.

You don't. It will try the Insert first, and if that fails - update it. The antithesis of the other option.

Well, there's one way to find out - try it and see.

Or ask your Support provider for a definitive answer one way or the other.

Search the forum for JobMonApp - been discussed here quite a number of times before.

Again, assure that all of your queries are as efficient as possible. I suspect they can be improved because your current performance is horrid, but who knows. For example, check to see if any new indexes would help.

Either that or get a waiver from the Powers That Be. Redesign the jobs.

Another option - what specific Oracle client version are you using? I've seen similar behaviour, random 'junk' characters added to fields, with certain versions of the client. For me, it was specifically a 10g client and we had to 'downgrade' to a 9i client to get it to work properly, even though th...

There's no reason for a Server job to ever log a warning, so one bit of advice would be to fix your job. We have two or three thousand that run nightly across the enterprise with nary a peep.

Other than than, work around it as you've shown or wait for the official answer.

Have you checked your documentation to ensure that all this functionality is even in the 7.0 release? From what I recall, the initial implementation was pretty weak and it required a recompile to get it to notice changes in values. I don't think it all "works works" until the 7.5 release. Can't say ...

Then you need to contact the development team and get the gory details as to what exactly DSShell is and how it is coded. As noted, it does not come with the product and does not seem to be working properly.

If you can, it may help to post the code here, wrapped in [code] tags.

If that's true then I'd report it as a bug to your Support provider.

Yes, best to do that if you can unless your database sort speed is horrible. Oh, and...

You are welcome.

Actually, the post says it contains some of the names. Not sure where the rest will come from. You'll need to read the file in and use the resulting string to populate a Job Parameter for use in the stage. Or if the list is 'too long' or you want people to get individual emails, you'll need to craft...

Gazelle wrote:This has turned my understanding of rows/sec upside-down, and it makes the figure pretty useless in my opinion.

Somewhere, Ray is clapping happily.