DSXchange

IsValid()

In the Administrator under Projects, after clicking on the 'Command' button.

First thing I'd do is take those two messages to my DBA, see if they know what they mean. Have you done so?

But doesn't that confirm that TO_DATE must be internal to DS if it's not available in SQL Server? Hmmm... I get what you are saying and I really wish I could explain the behaviour you are seeing but that still doesn't make it internal to DS. All DataStage should be doing is passing that sql to the ...

Like there's no frustrations working with PX.

How about explaining what you'd like to do? Without using the word 'schema'.

It really wants you to add a second transformer to do the third lookup. However, while you can't drag the key reference, you can simply type it in. Yes, it will stay red but will work if you've done everything correctly.

The problem solution mentioned in the linked post is not Premium Content.

Did you do a full uninstall? That means cleaning up the registry and install disk to remove *any* traces of the old client before installing again. That and rebooting.

Odd that it's prompting you for a password, it really shouldn't. See if anything in this post helps, sounds like you may have an ownership or permissions problem. Especially seeing as how it also 'cannot open log file'.

New install that's never worked? Working install that suddenly stopped working?

OK, that question should always come up when deleting a large quantity of records and wanted to get it out of the way.

Aborts how, Lance? How is 'CurrentJobHandle' derived? Wondering if it should be DSJ.ME in those circumstances when it aborts.

As noted, simplest to run it from the Adminstrator client - Projects / select the project / Command, then input the SQL as the 'Command' and click 'Execute' to run it.

"1010" is the binary representation of a decimal 10... 8+2... not two 10s stuck together.

Suggest you check closer next time from the 'Clean up resources' tool. Don't always expect to find your job name there, sometimes all you'll find is a reference to one of the underlying objects by job number. For example, if there really was a process holding the job's log you would have seen a refe...