DSXchange

Actually no. But if you don't have a where clause - like when selecting a sequence - you cannot mark a key field. Key field = where clause required.

Not typically a DataStage thing. See if this helps. Lots of other resources out there, btw.

You get this error when exactly? Doing what?

Are you having some sort of... debugging crisis?

It's all about the Ray.

As noted, there's no limit to what can be attached, however there will definitely be a limit on how much you can successfully email.

There seems to be a property in the ODBC Connector stage to control that, but no mention of anything of the sort in the documentation for the Enterprise stage.

Perhaps it is related to the choice of an unsupported platform...

ASAP? Seriously? Contact support for that.

As noted.

Which is why the suggestion was to make sure both sides were simple string fields in identical formats (say, YYYY-MM-DD) to make this happen. Drop the time from the process if you just need to compare the dates.

Unlike any other stage, ODBC doesn't care if you don't bind all of the columns in your link into the SQL. So yes, you'll need at least one field in the link but you won't need to use it anywhere.

:!: I suppose someone at your site felt it was necessary, but I personally am very against having it ever be used as a project default. It changes the behavior of DataStage in ways that are important for 'some' jobs needing the performance boost --- but it should only be used with extreme awareness....

No TeraData here, not sure if that's good or bad.

Thanks for all the suggestions, we'll see what comes of all this.