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: