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. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

DTLDESCRIBE FKEYS General Notes

DTLDESCRIBE FKEYS General Notes

For metadata requests, the qualifiers will, as a default, be converted to the case that is standard on the source database, for example, uppercase for Oracle. Hence, supplying a qualifier1 field of scott or SCOTT will produce the same results because both will be treated as uppercase.
Alternatively, by setting the Respect case 1 option to Y, this defaulting to the database case will not be done. Hence a qualifier1 of scott will produce no results, whereas SCOTT will be successful.
Respect case 2 is relevant for qualifier2 and Respect case 3 is relevant for tablename.
The metadata qualifiers support wildcards as follows:
  • *
    - one or more matching characters
  • ?
    - a single matching character
If either of the wildcard characters are used within a column or table name, precede each occurrence of them with the escape character.
For example, a request for tab* would list all tables beginning with tab, whereas a request for tab~* would list only the table that was named tab*.
Therefore, to list only tables called s*ott in lowercase and return comments this SQL could be used:
dtldescribe tables,s~*ott,,,Y,,,Y

0 COMMENTS

We’d like to hear from you!