External Target stage: fast path

InfoSphere® DataStage® has many defaults which means that it can be very easy to include External Target stages in a job. InfoSphere DataStage provides a versatile user interface, and there are many shortcuts to achieving a particular end, this section describes the basic method, you will learn where the shortcuts are when you get familiar with the product.

To use the External Target stage:

• In the Input Link Properties Tab:
  • Specify whether the stage is providing details of the program (the default) or whether details will be provided in a file (using the latter method you can provide a list of files and arguments).
  • If using the default target method, specify the name of the target program executable. You can also specify required arguments that InfoSphere DataStage will pass when it calls the program. Repeat this to specify multiple program calls.
  • If using the program file target method, specify the name of the file containing the list of program names and arguments.
  • Specify whether to delete partially written data if the write fails for some reason (True by default).
  • Specify how to treat rejected rows (by default the stage continues and the rows are discarded).
• In the Format Tab specify format details for the data you are writing, or accept the defaults (variable length columns enclosed in double quotes and delimited by commas, rows delimited with UNIX newlines).
• Ensure that column definitions have been specified (this can be done in an earlier stage or in a schema file).