DSXchange

datastagenewbie wrote:sometimes I wish I was a premium member.

That, at least, is easily remedied.

The original requirement explicitly stated a desire NOT to remove duplicates. gssr's solution is apposite.

That's a fairly common, and unfortunately not very helpful, message in DataStage/QualityStage parallel jobs. It is not particularly relevant to the stage type (operator) that generated it. It means usually that an operator process has failed (not the same as failed to start) but does not give any me...

Possibly.

Of course, your DBA may not have configured that many listeners, so your job (at least one of its nodes) may fail.

It may simply be that you lack SELECT privilege on the system tables that contain this information.

Ray, I couldn't see your complete message so don't know what you said :( That's because you have not yet obtained yourself a premium membership. Once you have that you can read the entirety of the posts of the premium posters, as well as having quite a few other benefits (such as discounts at the D...

Here is the full documentation, according to me. The Sequencer activity has one or more inputs and one output. If its sole property is set to "Any" then the output triggers as soon as any of the inputs fires. If its sole property is set to "All" then the output triggers only when...

Is the night run under a different user ID from the one used for the successful run?

Moderator: topic relocated as requested

The answer for a server job is to use the Ereplace() function.

Please mark this thread as Resolved using the green button at the top of this page.

You're not comparing apples with apples so most comparisons are probably unfair. The thing I most like about UNIX over Windows is the infrequency with which the machine has to be re-booted - that is, its "up time". On identical hardware there theoretically should be little difference betwe...

Yes, that seems like a reasonable requirement. What do you get out of DataStage when there ARE records in the file? How are you calculating this? Think about how any calculation could be performed if no records are passing through the job. What you need to do is to detect whether the file is empty (...

They're all listed in the Designer manual. From memory it's Ctrl-E, but I've not used that for a very long time.

Connectors in server jobs - in "version next" (see above). And the migration tool will handle server jobs also.

I got the feeling that, if you use this tool for your upgrades, you don't get given a choice about whether or not to change to Connectors - it happens.