Filter
Top Products
Examples of Supported Query Expressions
■
{fn LCASE(mp3.artist)} LIKE ’%floyd% ’ AND system.object_size > 2000000
■
(object_size < 200) OR "Collation" = ’en-US’
■
{fn TIMESTAMPDIFF(SQL_TSI_YEAR, system.test.type_timestamp, ’2007-04-02
01:50:50.999’)}<3
■
{fn TIMESTAMPADD(SQL_TSI_YEAR, 2, system.test.type_timestamp )} > ’2007-04-03
01:50:50.999’
Queries Not Supported in Version 1.1
The following JDBC escapes are not supported:
■
CHAR(code)
■
INSERT(string1, start, length, string2)
■
LEFT(string, count)
■
REPEAT(string, count)
■
REPLACE(string1, string2, string3)
■
RIGHT(string, count)
■
SPACE(count)
■
ROUND(value, number)
■
TRUNCATE(value, number)
■
POWER(value, power)
■
ACOS(float)
■
ASIN(float)
■
ATAN(float)
■
ATAN2(float1, float2)
■
CEILING(number)
■
COS(float)
■
COT(float)
■
DEGREES(number)
■
EXP(float)
■
FLOOR(number)
■
LOG(float)
■
LOG10(float)
■
ASCII(string)
■
MOD(float1, float2)
■
PI()
■
POWER(number, power)
■
RADIANS(number)
■
RAND(integer)
■
SIGN(number)
QueriesNot SupportedinVersion1.1
Chapter4 • SunStorageTek 5800SystemQuery Language 123