| Contents |
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 |
7
