DSXchange

Doesn't really matter as (bottom line) the file creation cannot be avoided. The stage creates the file when the job starts, regardless of 'flow'. Arnd has noted the typical 'workaround' for this.

[sigh]

Start here:

http://ora-24329.ora-code.com/

There's also this:

http://www-01.ibm.com/support/docview.w ... 1websphere

Not sure if it applies or not, but a google for your error turned up this.

Define 'not working'. Be precise about what it is or isn't doing, please.

First step would be to re-post your question in the correct forum. For PX questions, that would be the Enterprise Edition forum. This one is for TX questions, a completely different product.

Still think there's a way to do it without that... but no way to check right now.

Or something like so to set a variable you can test and conditionally act upon:

Missed that.

I would probably script something rather than trying to do it all in "one line" but look into "ls | wc -l" with a result of > 0. You'll also need to redirect STDERR to suppress the "no files found" message that comes with the zero.

say2prabhu1 wrote:The above logic will applicable only for fixed columns

Delimited columns.

Still lost. It seems you want to modify the source XML as part of your database load, which is ok I suppose. However, there are no italics in XML - that takes HTML so your requirements need a little adjusting. Unless I'm being especially dense today.

OK, what's different about the "short" records? Do they only have 19 fields in them?