DSXchange

What kind of 'interrogation' are you planning? A simple notification stage linked to an Exception Handler (since this is version 6 we're talking about) will email out the problem encountered and the job it happened in. Or run all of your failure links to a Sequencer set to 'Any' then to the Notifica...

You're almost there. The only way to properly capture rejected records from an OCI stage is to keep your Array Size set to 1. Anything higher and, while the number of records written will be correct, the actual contents of what is written will be from the wrong records. Sad but true. I would use lin...

Actually, it's a pretty common tactic for phpbb boards like this, I'm surprised we haven't seen them before. That's why you'll see more and more 'tricks' to fool spambots during the registration process - all in an attempt to ensure there is a real live well-intentioned human on the other end... not...

I sent an email to Walter and he nukethed them from orbit.

What in the world would any of this have to do with DataStage? Use TOAD or sql*plus.

From my standpoint, I'd want to be assured that a) the transformer is in place and b) the errors continue even with it there, before too much more time is spent on this. I'd also like to see what these look like now, not what they may or may not have looked like in the past. Otherwise we're chasing ...

... and the warning messages are?

Ray still has the scar from that time when... well, never mind. It wasn't a pretty sight.

Dealt with 200MB and 300MB packs, too. Heavy, noisy and God Forbid you dropped one.

Peoples, this is a Spambot for a porn site. Suggest you just ignore all of 'her' posts and keep your hands in your pocketses as you walk on by...

bcarlson wrote:I know what DBX is - it is a debugging environment on Unix. How is DataStage using it and why?

Not on my UNIX system, for whatever that may be worth. It doesn't seem to exist here.

Ah... those were the days! The first machine I worked on as a professional used CDC 'Hawk' drives, from what I recalled. One fixed platter and one removable platter about the size of a pizza and in a 'cartridge' about two or three inches thick. The fixed platter stored our O/S and the removable plat...

Yup, many moons ago I posted such. I checked your previous post and I found a korn waiting style script, didn't notice anything for Winders...

So... you changed a routine called 'ForceWarn' to no longer force a warning? Not the approach I would have taken.

DSguru2B wrote:Doesnt it spit out a warning if file doesnt exist for the very same reason ?

I believe that is a true statement. May or may not be an issue for folks, if so a quick "if -s" or other UNIX file check could easily be run in a Command stage. For Windows... [shrug]

The WFF stage will do both, for the latter tell it to wait zero seconds and you get an existence check.