Example of an Export Task
Suppose that the Travel Agency wishes to export details of Scheduled Tours for which no reservations have been made, so that this information can be used by management in an external application.
The SQL statement for this would be as follows:
FROM schedtour st
WHERE NOT EXISTS
SELECT ' '
FROM reservation r
WHERE r.schedtour_id = st.schedtour_id
If the file format chosen was FIXED, the resulting output file, if opened with WordPad, might look something like this.
This file can, of course, then be read into an appropriate application. In fact, an action task could be used at the end of the job to start the application and read the file automatically.