skip to main content
Schema Management : Implementing Schema Objects in C/C++ : Pattern Value Arguments
 

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