DSXchange

I fully agree. The load utility for DB2 does not have this kind of functionality. Do it in a Transformer stage.

You would need to create a small executable (probably in Visual Basic) that invoked Excel and ran the macro. DataStage itself can only access Excel via ODBC, and there is no mechanism within ODBC for running Excel macros. DataStage can, however, invoke the executable via ExecDOS as a before/after su...

Either use the ODBC driver for text files and mention only the desired columns in the SELECT statement, or within ProfileStage identify those columns that are to be excluded from analysis.

The same way you would if doing it the same day. On the ProfileStage Menu Map choose Analysis Reports (it's in the top right hand corner). Or choose Reports from the main menu, and Column Analysis from there.
You can export these reports into a number of different formats.

Simply check the Multiple Row Return check box in the Transformer stage (reference) input link properties.

In this context "plug-in" really means "non Enterprise". For parallel jobs there are Enterprise stage types, with inherent parallelism, and "plug-in" or "API" stage types which are modelled on their server job counterparts and have limited parallel capability.

Never assume anything about sorting or partitioning. Design it in explicitly.

As to whether you can simultaneously append to the same Data Set, do let us know. Also open the Data Set management tool and tell us whether each job has created a separate physical data file on each partition.

An after-job subroutine has only a single input argument, containing anything from the Input Value field. You need to parse out the names from the InputArg argument. You can use DSJ.LINKROWCOUNT to get the total rows across all partitions - you don't need to add the separate partitions as in the cod...

I'm afraid I don't understand this latest question in the context of the earlier posts in this thread. What temp? What is Stu? What is the significance of line 4?

What have you already searched for?

It's a different concept in parallel jobs. You don't have a separate concept of plug-in stages. Rather, you right click on Stage Types in the Repository and create new Build or Custom or Wrapped stages. All is explained in the Parallel Job Advanced Developer's Guide

Why do you claim that the IsNumeric() function is not available? Are you using the expression editor to construct your expression?
If it truly is unavailable, you might like to explore the IsValid() function.

No. It's a manual process. Follow Craig's instructions.

The first job in a sequence runs, and processes zero or more rows. In a routine activity you determine, probably via a call to DSGetLinkInfo(), whether the row count was zero or otherwise. A custom trigger on the routine activity then determines whether the second job, which generates the "all zeroe...

In these jobs did you use a copy of, or a reference to, the shared container?