Producing Header or Footer Lines in an External File

Previous Next

See Also

To produce a header line in an external file:

1. Specify the main export task with output file <file1>, and embed it in a batch job.
2. Define an E_DUMMY external set with SQL statement:

SELECT  '<Header message>'

FROM    dual

You have to use a single-record dummy table here.

3. Define an ET_DUMMY export task based on the E_DUMMY external set and with output file <file1>.
4. Add the ET_DUMMY export task to the job, giving it a lower sequence number than the main export task.

To get a footer line, use the same strategy with an export task at the end of the job.