Producing Header or Footer Lines in an External File

Previous Next

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.