DSXchange

Typically one would make the 'lowest level' the repetition key, so try marking the User instead of the Group as such.

Does XMLSpy tell you this is well formed? You've got an extra </CD> tag in there...

You have a field called 'file name' that you are not in fact putting the filename in, but rather the contents of the file instead. Ernie suggested using the External Source stage to perform an 'ls' to get the actual filename and then set the XML Input stage to URL/File path. This lets the XML Input...

First off, as Ray asked, is "mdsCountLines" a custom routine? Is it properly compiled and something you've used before? Secondly, I really don't think you can call routines like that directly in your trigger expression. I would suggest you use a Routine Activity stage to execute the routine and then...

Depends on the complexity of the filter command, I would think. But generally, I'd say no.

It came off the front page some time ago because it was causing 'issues' with the page load speed. There was talk about creating a new page for it, but I don't think that ever happened.

I just click on Ray's name in any of his posts to see how badly he continues to wallop all of us.

I have projects with several thousand jobs. Properly setup your search shouldn't take all that much time to do, especially if you are querying a database table you created just for this.

Hmmm... Arnd gave you a far more complete answer than I did.

Back to your original problem as stated, there shouldn't be an issue using an encrypted password in any DB stage. What makes you say you are "unable to achieve it"? What exact issue are you having?

Whatever the code we do with server job, is it possible to do with parallel job?

Basically, yes. Doesn't necessarily go the other way.

If Yes, which one is better server jobs or parallel job?

Better? Depends on the task.

Which will have the future, Server or Parallel?

Parallel.

Do you have a particular reason for asking this? More detail will get more better answers. You can build a 'loop' in a 7.5.x Sequence job, by the way.

You tell us. I thought you were going to post the exact version of DataStage you are running?

ps. 'Sink' is where dirty dishes go, you mean 'sync'.

Of course, an after-job routine or script can execute your stored procedure. Suggest you code a script and get it running outside of DataStage first, then add it to your job.

At some point soon here, I would think you'd be better served by opening a case with your official Support provider rather than continuing to thrash here.

If you want the project default value when the job runs, don't mention the parameter name when you run the job from UNIX. Let it take the default.