Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Example: Database Uses Keywords or Special Characters in Identifiers

Example: Database Uses Keywords or Special Characters in Identifiers

In this example, the database uses keywords or special characters in some identifiers. The database uses identifiers that are not case sensitive.
In the database connection, configure the identifier properties as follows:
  1. Set the
    SQL Identifier Character
    property to the character that the database uses for delimited identifiers.
    This example sets the property to
    "" (quotes)
    .
  2. Clear the
    Support Mixed-case Identifiers
    property.
When the Data Integration Service generates SQL queries, the service places the selected character around identifiers that use a reserved keyword or that use a special character. For example, the Data Integration Service generates the following query:
SELECT * FROM "MYTABLE$@" /* identifier with special characters enclosed within delimited character */ WHERE MYCOLUMN = 10 /* regular identifier not enclosed within delimited character */

0 COMMENTS

We’d like to hear from you!