Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

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!