If the database encounters any errors while the SQL Selector operator is retrieving LOB, JSON, or XML data, the job will be terminated with error messages.
If any errors occur on the client side (for example, if there is an I/O error while writing LOB, JSON or XML data to a file), the SQL Selector operator issues an explanatory error message and terminate the job.
When a client-side failure causes the SQL Selector operator to terminate the job, the temporary work files that it creates to transport LOB, JSON, or XML data from the source table to the target may not get deleted.
- If the target is another database table, which means the consumer operator is the SQL Inserter operator, then that operator deletes these temporary work files upon error termination.
- If the target is a flat file, which means the consumer operator is the DataConnector operator, the files are not deleted; they remain after the job terminates. Users must delete these files manually.