DSXchange

DS_JOBS has a job type indicator that can be used to filter by job type. This has been shown before; a Search will find it. There is a recent (currently active?) thread on getting the job list from a sequence. Are you interested in design time (all the job activities in the job sequence) or run time...

Stand alone on brand new Linux server. The conventional UniVerse database is still there, and still updated.

Currently, it seems to me, BOTH repositories get updated - the common repository (via WAS) and the "old" repository.

The Control Panel applet is simply called DataStage - there is no "Administrator" in its name.

You can also stop and start the DataStage services individually if necessary using the Services applet in Control Panel.

How Can We Categorize the records on the source file for Investigation. I am not certain what you mean by "categorize". Can you please explain in some other way? The dictionary specifies the layout of the record, and may have any kind of synonym you need. There are also three different kinds of inv...

You can NOT make such sweeping generalizations. If the next stage downstream of a Transformer stage is a DB2/UDB Enterprise stage loading a partitioned table, for example, then probably the best partitioning algorithm for the Transformer stage (and, if possible, any upstream stages) is DB2.

The most efficient is just to keep passing POST_DATE along all the links until you don't need it any more. You can do whatever you like in a parallel routine, provided that you can encapsulate it all in C++. For example, you could use the functions of the ODBC API. (This is NOT a part of DataStage, ...

There is no routine "out of the box". However you could invoke the oerr command through your own routine via DSExecute subroutine.

Post the exact error message. Any partitioning is permitted on the input to a Transformer stage, subject to the Preserve Partitioning flag of the stage upstream from it.

No.

(Auto) leads to Round Robin except:

on reference input to Lookup stage - Entire

on inputs to Join and Merge stages - Hash on join key(s)

on DB2/UDB Enterprise stages - DB2

on other parallel to parallel with same degree of parallelism - Same

Using a routine is going to be WAY too slow. However, the answer to your actual question is that what is returned is the entire output of the command - you have to isolate the field (line) in which your result is displayed, for example Field(Output,@FM,3,1) or simply Output<3>. The SQL could include...

Read the error mesage more carefully. It's the /tmp file system that filled.

Over to you, Joshy...

I don't think dsjob has been enhanced to use parameter sets directly. You still need to supply values for individual parameters where you wish to replace the default value. Refer to a parameter in a parameter set using standard dot notation: setname.parametername.

Of course it's been defined. It's basically the old MetaStage hub, with a few extra tables and a couple extra columns in some of the tables to identify a wider ranges of sources uniquely. However, the definition of the common Repository is not in the public domain. The database is open, in that you ...