Sun Microsystems Sun StorageTek 5800 - Manual (Page 122)

■ expr [NOT] IN (valueslist) .
Note – The 5800 system emulator supports (but the cluster database does not) a JDBC
“escape” clause that allows you to treat either % or _ as constant characters. There is
currently no way to accomplish this in a LIKE clause in a query on a live cluster.
■ The following JDBC function escapes have been tested and are supported:
– {fn UCASE(string)} to convert a string to uppercase.
– {fn LCASE(string)} to convert a string to lowercase.
– {fn ABS(value)} to take the absolute value of a numeric expression.
– {fn LENGTH(string)} to get the length of a string.
– {fn SUBSTRING(string, start, length)} to get a character string formed by
extracting length characters from string beginning at start.
– {fn LOCATE(string1, string2[, start])} to locate the position in string2 of the
first occurrence of string1, searching from the beginning of string2. If start is
specified, the search begins from position start. 0 is returned if string2 does not
contain string1.
– {fn LTRIM(string)} to remove the leading blank spaces in a character string
– {fn RTRIM(string)} to remove the trailing blank spaces of a character string
– {fn CONCAT(string1, string2)} to get the concatanated character string by
appending string2 to string1. If a string is NULL, the result is DBMS-dependent.
– {fn TIMESTAMPDIFF(interval, timestamp1, timestamp2)}. An integer representing
the number of interval by which timestamp2 is greater than timestamp1. interval
may be one of the following: SQL_TSI_FRAC_SECOND, SQL_TSI_SECOND, SQL_TSI_MINUTE,
SQL_TSI_HOUR
, SQL_TSI_DAY, SQL_TSI_MONTH, SQL_TSI_QUARTER, or SQL_TSI_YEAR.
– {fn TIMESTAMPADD(interval, count, timestamp)}. A timestamp calculated by
adding count number of intervals to timestamp. interval may be one of the
following: SQL_TSI_FRAC_SECOND, SQL_TSI_SECOND, SQL_TSI_MINUTE, SQL_TSI_HOUR,
SQL_TSI_DAY
, SQL_TSI_WEEK, SQL_TSI_MONTH, SQL_TSI_QUARTER, or SQL_TSI_YEAR.
■ field_name IS NOT NULL to return all objects that have a value for a specific field. In
particular, the query "system.object_id IS NOT NULL" can be used to query all the objects
in the system.
Note – The form "field_name IS NULL" to identify all the objects that lack a value for a
specific field is not supported and will not work properly in all cases.
Supported Expression Types
Sun StorageTek 5800 System Client API Reference Manual • June 2008 122