DSXchange

So, go back and edit your first post. Correct the code you posted so it matches reality.

First suggestion, add some 'breadcrumbs' so you know what's going on inside the routine. Use DSLogInfo to push both the 'ToCmd' and the 'output' from the call into the logs as a starting point. Also seems to me there should be more to the error message than what was posted, is that all that was logg...

So this IBM Rep installed the compiler for you but never actually tested it to make sure it was working properly with DataStage?

Someone else will have to answer your question, I didn't have any luck this morning trying to track down that information on IBM's site. [sigh]

Are you current on your fixpacks? Have you opened a case with your official support provider yet?

My idea was, only when the data is ready to be processed by the connector stage, the pre-sql statement will be executed before any row is processed by the connector stage , and not as part of any other stage that lies before of the connector stage, within the job. And for the record, what you found...

First suggestion would be to ensure you are using a compiler version that is officially supported by both your platform and version.

Was wondering if "It's something new" means this used to work and stopped but I doubt it. I don't see any mention of the project name.

ray.wurlod wrote:This functionality is available in version 9.1, in the form of Workload Management Queues.

Interesting... any details out there on exactly how that will work?

No such parameter exists. You need to limit their execution. If you are using Sequence jobs as job control then that means redesigning them in some fashion.

So... what happened?

If I remove the "Generate Formatted Output" check box, entire record is displaying in single line. As it should. XML does not need any special formatting, it's just "noise" to the parser as Ernie noted. Open it up in your browser or something that understands XML if you want to ...

Can't really help but wanted to say thanks! for actually practicing what I've been preaching - start your own topic and link back to any you need to reference.

:D

Andy said to use 'Target' if it only takes input. That's clearly not the case for you. Even though it is being used as a source, have you tried setting the type to Transform?

The plug-in is there for backwards compatability. Use the connector.

That depends entirely on where your logs are stored, which is dependant on the RT v. OR logging as noted here amongst other posts. Assuming you have "RT" logging enabled, then you need to determine the job number associated with the job in question and you can then issue a CLEAR.FILE for t...