DSXchange

I need to store the previous value of the row to get the running total. No, you don't. You need a 'previous value' to do group change detection, not to maintain a simple total. You've already got 'units' coming in on your source link so no need for another variable simply to hold that. Create one s...

Wow... and from the Oliver list in 2002 no less.

Yes, but the license comes along for the ride. You won't see the Oracle Enterprise Stage when working a Server job as that is not a Server stage - it is a PX only stage. You should have the 'OCI' stages instead for Server.

Or! Check out the FMT command.

The 'parallel' or Enterprise Edition supports both Server and PX jobs, so no need to think you need to convert everything. Simply import the jobs. They should run as-is with the obvious difference of anything O/S related. Anything routine or script related (etc) that assumes Windows will more than l...

Why the dump to a flat file? Do you really need to do that or do you just need to clear it as your subject states?

Why in the world repeat this post? Stick to the original, respond to the question posted there, please.

Then unfortunately it sounds like you'll need to wait for the xsd.

Doesn't the Summary call give you the ids for all of the entries? Seems like you could take the ones you are interested in and call DSGetLogEntry specifically for those.

I'm note sure you can take it down to that level. All I've ever seen is something like:


Contact your support provider if no-one has anything more specific to add.

So... they're not going to give you an xsd?

Point the importer to your dtd file, pretty sure it will accept that. Import the metadata in the same manner as you did before.

That's pretty old school. If you generated it from the xml, I'd be inclined to not use it. Best to get the xsd and use that.

Perhaps, but it stands a very good chance of being incomplete or incorrect. Request the xsd from whomever you are generating the xml for, your external vendor in this case.

First suggestion would be to import the metadata from an xsd if at all possible, not from the xml itself. That can help tremendously.

Pete Morris wrote:Is there a TCL command that will tidy up a corrupted job.

As noted earlier - DS.CHECKER - but the answer could depend on exactly what you mean by 'tidy up'.