Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool 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!