DSXchange

Without hiring IBM so they can leverage their software solution, the only other one open to you is wetware based.

Actually, Craig did specifically ask him to remove the Exception Handler. As you suggested, I tried running the master sequence after removing the exception handler and kept the triggers intact. But still the master sequence was showing 'Finished(See Log)'. And it was not getting aborted. What exact...

In other words, hire competent DataStage consulting. From IBM.

Or, more simply, a view.

Sure, excellent point, we do the same thing when multiple files are involved - especially if they trickle in over the course of the day. Didn't mention that as we were talking about a single file.

You can only know that if you join on the two key columns not one. Otherwise it will need to be purely positional.

Craig as you've said to load data into the database i've done for the input source of hash file.But for the source of job2 i'm not able to create a table in oracle 9i of a single column of length around 50000 and datatype is CHAR. Of course not, there's no such thing. That's even too large for a VA...

For the former, the record id would be logged as '<Missing or NULL>'.

Not a link nor a line. Joe, why not post the compiler error? It notes the problem and why your Key Expression is red - it doesn't like the 'Range' function you are using there... where did you get 'Range' from?

In other words, you'll need to be more explicit. Examples are always good. Well... as long as they are good examples.

'Computing an expression'? Are you manipulating this decimal field in your sql or just trying to select it? Perhaps you could post your sql.

There are configuration steps that need to be performed before you can use Oracle with DataStage. I know what they would be for a UNIX server but not for Windows, sorry. But it should be documented, check your pdf docs. And there's more than just the stage at play here. You must have an early 7.x ve...

Exactly. Have a chat with your UNIX system admins, ask them.

Ha! My lawn is still 'dormant', a loverly shade of brown and crunchy hard. Too bad I didn't know about this shindig, could have used a break and a trip to sunny FL.

Enjoy! :D

You never said what the 'useful information' was that you found when you reset the job, so can't really comment on the descriptive nature of it. You also haven't said what about that caused the abort - depending on what you are doing with the date, the lack of delimiters could have been handled fair...