DSXchange

Yeah, that.

Not something I'd advocate from within DataStage. If your job is invoked from the third-party scheduler, however, then it's a simple matter to invoke the appropriate commands to stop and start the server from the same scheduler. I'd script in a couple of safety checks, also. One that there are no ot...

OK, fields 4 and 8 both seem to contain the Message ID. Neither of these - as you noted - is mentioned in the file dictionary. However the expression EVAL "@RECORD<4>" can be used in a query to access the contents of field #4. Or use Position 4 in the columns grid of a Hashed File stage.

TYPE is 5 for "Control", 1 for "Info", 7 for "Run Job" and so on. It does "double duty".

Put the user in a group that has SuperOperator role in DataStage.

(There is no role that allows for running of jobs but does not allow viewing of job logs.)

So what do you mean by "Event Type"? The TYPE column contains an enumerated value that maps onto the Type column in Director (and which is displayed as Event Type in detail log view) - is this what you mean?

Lookahead is basically not possible. There are techniques, such as stage variables, to remember the previous row.

Perhaps you could re-think your requirement? It may require two passes through the data.

But if you're after a moving sum, the Aggregator stage can do this.

They're getting there. WAS 6.0.2.127 is 64-bit and is the preferred WAS for DataStage version 8.1.

Good thinking, and it may work but it may not. Certainly with a normal reference link the reference data set is completely loaded into memory and an index built before the first lookup is attempted, which is the situation where it may work, provided the database does not continue to hold any lock un...

Presumably the input Data Sets are not changing between runs?

Can you give a couple of examples of input and output row counts? For example:

You need to list the dictionary of YOUR hashed file, not of RT_LOG ! If you know the position of the field in the data record, you can create an entry using that information in the Columns grid of the Hashed File stage, giving as the column name any legal name. The key column is position 0, the non-...

Waiting for question to be posted in Parallel forum.

If I were to answer the question here, my answer would pertain to server jobs and waste both your time and mine.

Director is only an interlude to a scheduler - not a scheduler in its own right. It has to provide the lowest common denominator of scheduler functionality on UNIX and Windows systems (or did, originally). There's nothing to stop you creating a script to schedule as many jobs as you like to start at...

Have you set up (a) authentication mode in WebSphere Application Server and (b) DataStage credentials in Web Console for Information Server?

Have you ever used a Merge stage, Srikanth? What row goes into the reject link - the one from the master input or the one from the update (reference) input? Also, please strive for a professional standard of written Engish on DSXchange. The second person personal pronoun in English is spelled "...