DSXchange

Known bug, for which a patch is available. Sorry, but I can't find it here or I'd pass along the ecase number as well.

Actually you don't need to redirect input or output as both are handled automatically. So, just the sed command in the filter and the full filename in the normal filename box.

You need to add the Oracle paths to LD_LIBRARY_PATH, not LIBPATH.

Don't use a Terminator for that purpose as you are not 'terminating' anything. Simply run to a Sequencer as the last thing in the job stream and the process will just stop gracefully and exit without any fuss.

Welcome! You could use something like sed in the Filter to remove any blank records.

I was trying to find an existing post where this was already spelled out, but couldn't turn one up. Thanks Ernie.

I assume the difference is the 1.0 XML PACK release versus the (now current) 2.0 release, yes?

No, I don't believe so. I'm sure he'll clarify when he comes back around to these parts.

Get rid of the double quotes for one thing. What is "+2 filename" supposed to do?

You need to find it.

That doesn't look like a stylesheet to me, or at least not one appropriate for DataStage. Did you find and follow the instructions for making the stage generate the xslt template and then modify that?

Yes, it will run until it finds a file or dies. There shouldn't be any hit to much other than your filesystem, which will be polled every... four seconds(?), I believe, for the file.

You're asking what a 'makefile' is?

http://en.wikipedia.org/wiki/Make_(software)

You'll need to copy/paste the URL, clicking on the link directly won't work because of the parens.

Sorry, guess I was thinking of something else - a DS.TOOLS 'logout', whih removes any locks as well. For this, you'll need to turn it over to an Admin AFAIK.

What does 'LIST.READU' or DS.TOOLS show?

I'm not convinced you actually need one, but the process to get what the stage is currently using (which is what you would modify) *is* documented. Check the 'Help' button from inside the stage from that tab or the XML PACK 2.0 pdf. I think you need to turn tracing on and then you'll find it in the ...

As long as you realize that will remove all periods, including ones not generated from the MCP conversion.