DSXchange

In particular, what data types are involved?

Is node1 a different machine from the conductor node?

Research the Derivation Substitution utility in the Transformer stage.

The flow chart is up to you. You could also write pseudo code. Create it in a job sequence and examine the generated job control code. That should get you started.

Have you marked id and the date as Key columns on the reference link?

I don't know any way to retrieve the part number from DataStage software. Maybe there's a hidden file in DSEngine directory. Ask IBM through your support provider.

Not if you won't answer my questions.

You really need to do it, and you really do need to shut down (and, of course, start) the servers in the correct order. Shutting down DB2 while WAS and DataStage server are still running will cause you no end of grief.

Yes, that can be done. Find someone with enough DOS skills to show you how to do it in the Windows environment. Something like Or, if you have a UNIX emulator you can use the test command to determine existence.

You can do any pipelining that the operating system permits. For example
command1 ; command2 ; command3 ; command4
command1 && command2 && command3 && command4

Abort requires a reset, not necessarily a recompile. Automatic reset can be specified in sequences' Job activities, via "reset if required, then run" property value.

Need to see all properties of your Sequential File stage, and also the specifications in your Lookup stage.

The file on the server is in the &COMO& directory.

That's definitely not a DataStage question. Consult your system administrator for assistance with automatic start and shutdown scripts. If you want to amend the DataStage startup/shutdown script, you will find this in the location reported by the uv -admin -info command. Make very sure you take a ba...

Does your reject link have sqlcode column? Does your reject link or your job have a limit on the number of rows/warnings handled?