Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

RDBMSINSRTDFLT Statement

RDBMSINSRTDFLT Statement

The RDBMSINSRTDFLT statement controls whether PowerExchange uses default values for columns that you define with the WITH DEFAULT clause in an RDBMS.
All
DB2, Microsoft SQL Server, MySQL, and Oracle targets
No
RDBMSINSRTDFLT={
N
|Y}
  • N
    .
    PowerExchange uses PowerExchange defaults when writing data to columns that you define with the WITH DEFAULT clause.
  • Y.
    PowerExchange uses RDBMS defaults when writing data to columns that you define with the WITH DEFAULT clause.
    You must define the columns with a clause that enables the RDBMS to supply a default. Otherwise, an SQL error is generated.
Default is N.

0 COMMENTS

We’d like to hear from you!