Sun Microsystems Sun StorageTek 5800 - Manual (Page 7)

Supported Data Types ....................................................................................................................... 116
Queries ................................................................................................................................................ 117
Translating a Query to the Underlying Database ................................................................... 117
Attribute Format in Queries ..................................................................................................... 117
SQL Syntax in 5800 System Queries ........................................................................................ 118
Literals In Queries ............................................................................................................................. 118
Dynamic Parameters ................................................................................................................. 118
String Literals ............................................................................................................................. 118
Numeric Literals ......................................................................................................................... 118
Literals for 5800 System Data Types ........................................................................................ 119
Canonical String Format .................................................................................................................. 119
The Canonical String Decode Operation ................................................................................ 120
JDBC and HADB Date and Time Operations ................................................................................ 120
Reserved Words ................................................................................................................................. 121
Supported Expression Types ............................................................................................................ 121
Examples of Supported Query Expressions ................................................................................... 123
Queries Not Supported in Version 1.1 ............................................................................................ 123
SQL Words That Are Allowed in Queries ...................................................................................... 124
SQL Words That Are Not Allowed in Queries ............................................................................... 124
5 Programming Considerations and Best Practices ....................................................................... 127
Retries and Timeouts ........................................................................................................................ 127
Query Size Limit ................................................................................................................................ 127
Limit the Size of Schema Query Parameters and Literals ............................................................. 128
Limit Results Per Fetch ..................................................................................................................... 128
Index ................................................................................................................................................... 129
Contents
7