DSXchange

And? What about this is your issue or the part the "isn't working"? It would help if *you* explained what you were trying to accomplish with this rather than us trying to figure it out and make assumptions based on our look at it.

None that I am aware of. Why not ask your "UNIX experts" that question? Did you get any reason as to why they didn't like it?

You can google up the definition of a 'named pipe' if that concept is unfamiliar to you. However, that shouldn't be the difference between success and failure here.

How about explaining your job design? Saying you have a "fastexport job" doesn't really tell us much of anything.

I sat in on an overview presentation of the product at the last Vegas IOD meeting, but I can't for the life of me remember what they were calling it at the moment. Hopefully I can dig up my notes and post back more information or someone else will. I don't believe that there is any sort of 'official...

No need to write anything for Server when all kinds of functionality is already built in. As noted, 'Index' is a good answer here and the returned found position of the substring can be treated as a simple true/false Boolean when just checking for existence.

It would help if you showed us the actual syntax you're using and what exactly "isn't working" about it. Details are your friends!

lstsaur wrote:Fast Track comes with DataStage 7.x? What's Fast Track?

No.

http://www-306.ibm.com/software/data/in ... fasttrack/

Get a new DBA.

For that, you'd need to switch to a manual bulk load and specify that commit level as part of the control files. Or use a stored procedure.

Or you could, after job, start a scripted sqlplus session and run that file from inside sqlplus.

I remain unconvinced that you need to walk this path to solve your problem. The only time I've had to resort to an XSLT solution was when I had to... pivot... some incoming xml elements. Perhaps what you need to do is something the stage can't parse without help, but I'd wager you just need to get y...

No problem.

Which stage? For OCI it's 5 actually, but that doesn't change the answer - nope.

That should only be the case until you supply a Routine Name, does it stay disabled after you do that?

No, it does not. Anything secure - scp, sftp - you'll need to script.