$sql.metaData.getSearchStringEscape

Retrieves the string that can be used to escape wildcard characters.
Syntax
    $sql.metaData.getSearchStringEscape{jdbcProfileName}
DocumentationRetrieves the string that can be used to escape wildcard characters.
This is the string that can be used to escape '_' or '%' in the catalog search parameters that are a pattern (and therefore use one of the wildcard characters).

The '_' character represents any single character; the '%' character represents any sequence of zero or more characters.:

    Paramter:
      Requieres one parameter, this is your JDBC profile name.
    Returns:
      the string used to escape wildcard characters
    Throws:
      SQLException - if a database access error occurs
Examples
GroupSQL
Minimum required transaction-mode:NONE
Required scripting permission of the developerPERMISSION_FL_BASIC
Minimum parameters1
Maximum parameters 1
[Index] | [API-Index] | [Index-de] | © SITEFORUM Group, Germany | powered by SITEFORUM