Filter
Top Products
■
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
rst occurrence of string1, searching from the beginning of string2.Ifstart is
specied, 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,orSQL_TSI_YEAR.
– {fn TIMESTAMPADD(interval, count, timestamp)}. A timestamp calculated by
adding count number of intervalstotimestamp. 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,orSQL_TSI_YEAR.
■
field_name IS NOT NULL to return all objects that have a value for a specic eld. 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
specic eld is not supported and will not work properly in all cases.
Supported ExpressionTypes
SunStorageTek 5800SystemClientAPIReferenceManual • June 2008122