DSXchange

The after-job subroutine can be used to execute a command in an operating system shell (use ExecDOS or ExecSH as appropriate). This can be made conditional on successful completion of the job.

Welcome aboard.

The Join stage only performs an equi-join on sorted inputs.

Probably easiest is to copy one table into the other database and use that database's SQL capabilities to effect the custom join.

Has anyone used Business Glossary and/or Metadata Workbench in conjunction with Microsoft SQL Server MDS (formerly Bulldog, formerly Stratature +EDM)? If so, can you please either respond here with how you accomplished it, or reply off line?

In a parallel job you should be able to use an External Filter stage. This executes a well-formed UNIX command. Its sdtin is mapped from the stage's input link, and its stdout is mapped to the stage's output link.

That's an overly complex solution. It can be done readily with two stage variables. The only thing that is important is the order of execution (a) of the stage variables and (b) of the data (what does "previous" mean when the data are partitioned?).

How do you provide the file name to the job?
What is file date in this context?
What is batchno?

General question to all contributors to this thread: which of the suggested approaches is most efficient (fewest CPU cycles) and which is least efficient?

You can indeed click on a stage (name), or even on a link (name), in Director's Monitor view.
I tend to concur with Arnd's thought, without having run any tests.

If you have the software you have the tutorial - it's in the manual set.

You can find RedBooks by searching www.ibm.com.

If you want a server routine the main calls will be
DSGetNewestLogId()
DSGetLogSummary()
DSGetLogEventIds()
DSGetLogEvent()

Read about these in the DataStage BASIC manual.

I did tell you the correct procedure.

PS: Can you get premium membership?

You posted at 00:11 my time. I was not paying a whole lot of attention at that time.

Not exit alone.

It's easy to do if you use a "list of things" loop rather than a counted loop. If you must have a counter (and ask yourself why - there is no real need for a priori knowledge of the count) generate it using a user variables activity or, perhaps, an Execute Command or Routine activity.

... for US company names. EXPCOM is not really multi-national.