The SQL Inserter operator is a consumer operator inserts the data into a database table. An SQL Inserter operation is similar in function to a BTEQ import operation.
The SQL Inserter operator supports multiple instances and each instance can log one or more SQL sessions. Multiple, parallel instances can be used to improve the performance of loading data records into a target database table. The target table can be an empty table or a table with existing data in it.
- If multiple sessions are used and the data has duplicate primary index values, this could result in a potential database deadlock 2631 error. To avoid this error, do not use multiple sessions with the TPT SQL Inserter operator.
- If multiple sessions are used and the data accesses the same row-level lock on the database, the job could result in a hang. To avoid a hang, do not use multiple sessions with the TPT SQL Inserter operator. Use only one session.
The following figure shows the SQL Inserter operator interface.