DSXchange

As noted, I'm not using this expression in the Loop stage itself but rather in the Job Activity stage that receives the parameters from the Loop / User Variables stages.

No bug there, so...

You really shouldn't have to "pre-process" the list but can do the removal as you use them. This an example from one of my jobs, directly in the "filename" parameter in the Job Activity that the Loop drives:

http://www.dsxchange.com/viewtopic.php? ... ght=-64BIT

One example of many.

In other words, just like a Sequence job's checkpoints.

Might even help to examine that code.

In looking at the WebSphere DataStage System Requirements website for Linux, it shows both Redhat Enterprise ASE 2.1 and SUSE ES (x86) as valid operating systems. I'm curious what people are actually using out there in the wild, specifically for a 'non Enterprise' installation. Does the fact that th...

1) Sure, you can use a parameter to drive who gets an email. There's no "code" to modify for this, you simply use it in the stage.

2) No, not in the Email Notification stage. You can generate a 'dynamic attachment' and send that, or fall back on your own hand-coded email routine.

Be more specific. You enabled the MI option - but did you actually run multiple copies of the job at the same time? If not, then I would think your performance increase was due to other factors.

Just enclose the parameter name in pound/hash/# marks like usual.

Ask your DBA what this means: "Error 45 initializing SQL*Plus".

Been there, done that, got the t-shirt.

Ok, maybe they could help too.

Then you'll need to use a UV stage over the top of the Hashed File. Hashed files require all Key fields to be use. All.

Doesn't matter what you do or delete first - this little bit of stupidity happens when you have the 'create as XML' option checked by default in the Manager. Uncheck it.

You might want to expand a little bit on your question, Tom. Hashed File stage? Database stage? What does the phrase 'non-key columns' mean to you? Sometimes people confuse columns marked as 'key' columns with 'indexed' or 'primary key' columns, but it doesn't mean that at all, hence the question. A...