DSXchange

Good. If no-one here has an ideain the meantime, post back what Support comes up with so we're all educated.

You can build a process to feed the files to a named pipe and then the Sequential stage supports reading from a pipe. Click on Help in the stage to read about the 'Stage uses named pipes' option.

As noted, it's all on the CD. And 'the CD' means your DataStage Client software CDROM, it's not a separate product and everyone gets it for free.

Surprisingly, you're not the first to ask about this. Search the forums for 'ETLStats' for many (many) conversations on the subject. That or 'DSGetLog'.

You 'filter' by using a constraint. And those first two are derivations, while the third is what you would need to adopt for the constraint expression on the transformer's outbound link.

Please start your own thread, so we know your particulars, and also explain the details of your 'exact same issue'. In your new post. Not here.

You'd have to ask Dean Walker but I would assume that is the case.

Depends on your email setup. Should work but it may want comma space or it may just want a space. Try it and let us know.

And let me guess, user-defined sql? Or did the stage generate some for you? In either case, please post your sql.

jpr196 wrote:but I'm pretty sure no keys come near the 768 mark), correct?

You would get failures if you attempted to create a key over the limit.

That's the thing... I don't see an issue here.

What issue are we discussing with Oracle? As Ray has already noted, dropping the size of the varchar field will not result in a smaller hashed file and 480MB is not overly large.

"Numeric value out of range" isn't what one would typically see with a DATE field but then I don't typically use ODBC.

That was the next suggestion, a constraint to block them.

Only create the reject link?