|
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.
|
