Pattern Value Arguments

Some arguments in the catalog functions, such as the table_name argument in OASQLIP_tables, accept search patterns. The search pattern characters are:

• An underscore (_), which represents any single character.
• A percent sign (%), which represents any sequence of 0 or more characters.
• An escape character, which is specific to the driver or data provider, is used to include underscores, percent signs, and the escape character as literals. If the escape character precedes a non-special character, the escape character has no special meaning. If the escape character precedes a special character, it escapes the special character. For example, "\a" would be treated as two characters, "\" and "a", but "\%" would be treated as the non-special single character "%".

The escape character supported by your IP should be specified in the SQL_SEARCH_PATTERN_ESCAPE(=14) option value. The default escape character in oainfo.ini is set to ’\’.

See also

• OASQLIP_tables