Job Objective
Extract rows from database tables and write them to an external target file as delimited data.
Data Flow Diagram
The following figure shows a diagram of the job elements for Job Example 12.
Job Example PTS00016, PTS00017 – Extracting Rows and Sending Them in Delimited Format
Sample Script
For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:
- PTS00016: Extracting Rows and Writing Them in Delimited Format using the Export operator
- PTS00017: Extracting Rows and Writing Them in Delimited Format using the SQL Selector operator
Rationale
This job uses the:
- Export operator for exporting data from a database table with the schema that matches the table.
- SQL Selector operator for extracting data from a database table in field mode (character format).