DSXchange

Only if you post the full, unedited error message(s) first.

I said that because of your "Funny thing is the data gets loaded but he index rebuild fails" comment. The only time I've seen that is with unique indexes. A direct path sqlldr session disables all constraints and then, if you've loaded records with duplicate keys (which it will now happily...

Honestly, I have no clue. There are over 280,000 posts here and yours seems to be the only one that mentions that 'PXAdvRTOptions' variable. However, given your current state it doesn't seem like it could hurt anything and you could always put it back. BEfore doing that, you may simply want to try s...

There's a main DSEngine directory that you should check, plus directories named with each of your Project names wherever it was it was told to create them at server install time. Typically, from $DSHOME (which is the DSEngine directory) you can: "cd ../Projects" To get to them. Each one wi...

Sort of, you could do listings out to flat files and then use "diff" to compare them but by their very nature there will be differences. Might help, though.

If you haven't done so already, make sure to get your official support provider working on this as well.

Argh... check again.

I would check a couple of things right off the bat: 1) Space. Any chance you've exhausted all free space from the partition where DataStage and/or your Projects are installed? 2) I'd also do a 'reasonableness' check on the contents of your DataStage installation to make sure permissions haven't sudd...

OK, wrong word then. Double-sorry.

In other words, it means exactly what it says - you've got a 75 character string going into a 2 character string so truncation will happen. Fix whichever side is wrong.

Those ? parameter markers are positional, so first ? to the first column, second ? to the second column, etc. Adjusted for key v. non-key columns, of course.

No, it does not. It still returns the correct information, just apparently not the information you are expecting. Who you are logged in as has no bearing on what user DataStage jobs run as, so expecting them to match is unrealistic. There also seems to be a confusion with regards to the UNIX user an...

I have no DataStage access so can't check anything and have to go by what you posted. And what you posted means (if true) that there must be some sort of executable out there by that name if that is indeed a valid command line option. If you cannot find any such thing, suggest you contact your offic...

There are lots of ways to do this, and as noted you are just incrementing a surrogate key. Far simpler to create a 'sequence object' to control this in your target database or table, but since you haven't specified the database all you can get is generic advice. You could pass in the current max(id)...

Apparently yes, an executable named "iaJob" and which I would guess would be found in a bin directory somewhere under the IA installation.

It's in his "signature" at the bottom of every one of his posts.