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 Version1.1
Thefollowing 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)
QueriesNotSuppor ted inVersion 1.1
Chapter4 • Sun StorageTek 5800 System Query Language 123