DSXchange

Here's a crazy thought - read the documentation. The Designer Guide pdf has a chapter on Job Sequences where each stage is discussed 'in detail'.

So we get to guess what that acronym stands for? From a quick google, perhaps Sun Grid Engine? What is the context you found this in?

No-one will write up the crapload of differences between those three versions here for you. Assuming you have a 6.x version, why not contact IBM and ask them for the information? I'm sure they'd be happy to provide whatever information you'd need to make an upgrade decision.

Me? No, not really and unfortunately I don't have time to build my own test case and experiment with this. Besides, sounds like you solved your problem and your load happens in 2 seconds now.

Perhaps someone else has an idea. Guessing it's related to the Funnel and the unbalanced partitioning.

There's always the UNIX split command. Out of curiousity, why do you feel the need to split your input files in two?

Well... it won't start because it didn't stop. What's in the "stopServer.log" file that it mentions has the "error details"?

It really depends on what you're doing but you'd be amazed what Server can do in the right hands. :wink: I'm assuming here Server is not confusing Oracle and the explain plan is correct, hence the proper speed. The question still remains why that ORCHESTRATE syntax is problematic. Have you checked w...

Oritech wrote:I found the startup scripts in the /sbin/rc2.d folder.

Just as an FYI, that rc2.d folder is the standard place where "startup" type scripts are found on a UNIX server.

Have you considered using the Pivot stage for this? It converts columns to rows, after all. And the Sequential File stage can already read that as separate columns, given the proper delimiter.

Is it consistent on the project(s) it errors on or does it seem somewhat random?

Bejeebus, kind of like a broken record. If it didn't work before, why would it suddenly start working now?

What happens if you use this as your derivation:

Convert(StageVar1,"",LNK_ARNGM_CLASS.ACCOUNT_FIRST_NAME)

rep wrote:Does the documentation for the Ascential product fall under the same regulations as WTX documentation, because IBM bought the product?

Yes, of course.

Convert requires three arguments.

I seriously doubt they have licenses for all of those products.

Then in your source stage you use that id to select whatever keys you need from each record and send that to a target db stage set to delete. That or a Row Generator to 'generate' that id and a single record to the target stage that deletes all records with that id, if that's what you need.