DSXchange

Can you shed more light on reverse engineering of a "table .dsx"? Did you mean, export the table definition as a .dsx file and edit it accordingly? If so, how does this help in importing tables that are not yet present in IIS? He basically means to export an existing table definition (any...

Just some silliness.

http://en.wikipedia.org/wiki/Magic_8-Ball

mandyli wrote:Is there any issue with config file

Magic 8 Ball says... <shake,shake,shake>... "You may rely on it".

You always want the first occurance in the delimited string? If so:

Field(Yourfield,",",1,1)

I mean specifically that you rewrite the query to not constrain itself to one particular set of values but rather return all of the current 'bind variables' as fields in the query in addition to what is already there. That then goes into a hashed file and the 'binding' happens at runtime, a singleto...

By wrapping the sleep command within a Server Job, you free up the Sequence code from having to wait for the sleep command to finish. How so? You've said this a couple of times now and it has me a little baffled at the moment. Sleep is sleep, you really can't go off and do something else while it s...

Please be patient. Advice will come.

OCI is not a parallel stage, do you mean OE? What settings are you using for the Oracle side, both jobs? Particularly wondering what the PX 'Method' is.

Holey... no wonder that is slow, firing for each row. You need to see if you can restructure it to select all bind variables as key fields with everything else as data fields in a reference hashed file.

premium_membership.php

My first reply really should have been marked as Premium content as well.

Still think you should remove the OCI lookups to determine if they are the bottleneck and (if they are) then either replace them with hashed files or optimize the crap out of the reference query.

It should work with either. The difference from what I recall is whether they run all in one session or indivual sessions. Right, here we go: Each SQL statement is executed as a separate transaction if the statement separator is a double semi-colon ( ;; ). All SQL statements are executed in a single...

It's really wouldn't be that big of a deal to code, honestly. And realize this whole discussion started with two jobs, this is the first you mentioned your Master Plan. Glad you got a resolution in the end, regardless.

If your source is really a Decimal[38,10] and your target is Decimal[7,1] then no, it will always alert you to that possibility. What are the actual range of values in the source field?

Right, a single Sequencer stage. As noted, this is the closest you can get using the GUI as stages will always wait before moving on. To get your true, 'pure' staggered start, you'd need to code it yourself as I noted in my first post. I personally don't have an issue with that solution, there's ple...