DSXchange

Explain what 'existing_column + input_value' means. Sounds like you could just expand the same technique for all columns.

Kumar, at some point you are going to need to start a new thread. We can't deal with every single XML problem you have for the rest of your career in this one thread.

Post a sample snippet of your XML for us, show us the problem.

Q1. Is this error possible, if the db operation takes a long time? Yes, that could be one reason. Your DBA could supply more, I'd wager. Q2. Any idea what this message means? Where are the bounds set? Not sure, but since it doesn't have an 'ORA' component, guessing it comes from the DRS stage. Are ...

Put the existing row in a reference hashed file. Send the input row down an update link if the new value is less than the looked-up value.

Thanks - by 'reset' I assume you mean 'increase', yes? Any chance you could specify what values you increased them to and what value LDR_CNTRL needed to be set to? Edited to add: seems like from a quick Google that LDR_CNTRL is an AIX-specific environment variable. If that's the case, then this solu...

When you reset the job from Director did you get a 'From previous run...' message in the log?

There are two buttons at the very top of any post you create, one marks the thread as Resolved and the other marks it as a Workaround.

Have you tried... oh, I don't know... searching the forums?

That or get 'those people' to build you a proper file.

Curious - how can one have 'optional' fields in a fixed-width file?

First thought - "search forums for Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH to see if anyone else has ever posted it".

It's available in server jobs... with the 8.x release?

I want to use this as a source in my Datastage job. The problem is the file is located in Unix Env, where the path is differnet from our working directory path. That's not a problem, actually it's perfectly normal. Just specify the full path to the directory they are in (hopefully as a job paramete...

Yes, folder stage.

Why not just load directly into SQL Server from your source files? I don't see the point in first turning them into XML and then completely undoing that to load them back into your database. Regardless, yes - a Folder stage with a wildcard pattern to read them all and an XML Input stage to flatten t...