DSXchange

Make sure you spend some time researching what the various kill "signals" mean, specifically how "-9" differs from say a plain "kill" or a "kill -15".

True but the assumption that can be made is that since you would still meet the minimum, you should be OK. If you're specifically worried if there are any issues introduced by adding SP2 (much like what happened with our old friend XP) then I think you'll have to ask IBM that and see if they are awa...

You've marked your job type as Parallel hence all the grief about how lookups work. If you are actually working with a Server job (as you need to be for this example) then you should be ok. Since I assume you've already created DSLink3 at this point as a solid lined stream link, when you create the ...

Done via length semantics but not something I find DBA peoples are willing to change. Typically.

Double-quote madness, Ray.

Just to clarify, a 'conventional load' is still sqlldr, just with DIRECT=FALSE. It would still apply there. I meant it wouldn't apply to conventional sql, plain old DML done outside of sqlldr.

I have to trim trailing, leading spaces of all varchar fields. I am wondering if this can be acheived without changing the existing jobs. Trailing and leading? No, adding leading to the equation eliminates the possibility of any kind of automatic trimming. Double-checked and that "PRESERVE BLA...

Never heard of it but found this poking around. Curious what this has to do with DataStage.

You need to trim them where / why / of what? I think that APT variable may only apply to sqlldr operations but not positive.

What is the characterset of your target Oracle database?

Best to get that checked out, either by a DB2 DBA / support or DataStage support. Or both... one stop shopping.

Ah... missed that little nuance. Still, bracketing your search string with the internal delimiters can be a handy little trick for stopping substring matches. Generally.

Two problems - I don't believe 11i is supported for that and that process is complicated and not documented. You may be able to get something from your support provider, however, scripts or manual steps or something but you may be better off uninstalling and reinstalling everything. Assuming 11i 'wo...

Not really separate handling needed, just stick a ';' on the front of the string before searching.

So, are you trying to do what Ernie laid out here? If so, did you point the XML Input stage to the column coming in from the ES stage and set it to the 'URL/Filepath' option?