SupportedData Types ....................................................................................................................... 116
Queries................................................................................................................................................ 117
Translatinga Query to the Underlying Database ................................................................... 117
AttributeFormat in Queries .....................................................................................................117
SQLSyntax in 5800 System Queries ........................................................................................118
LiteralsIn Queries .............................................................................................................................118
DynamicParameters .................................................................................................................118
StringLiterals ............................................................................................................................. 118
NumericLiterals ......................................................................................................................... 118
Literalsfor 5800 System Data Types ........................................................................................119
CanonicalString Format ..................................................................................................................119
TheCanonical String Decode Operation ................................................................................ 120
JDBCand HADB Date and Time Operations ................................................................................ 120
ReservedWords ................................................................................................................................. 121
SupportedExpression Types ............................................................................................................ 121
Examplesof Supported Query Expressions ...................................................................................123
QueriesNot Supported in Version 1.1 ............................................................................................ 123
SQLWords That Are Allowed in Queries ......................................................................................124
SQLWords That Are Not Allowed in Queries ............................................................................... 124
5 ProgrammingConsiderationsand Best Prac tices .......................................................................127
Retriesand Timeouts ........................................................................................................................127
QuerySize Limit ................................................................................................................................127
Limitthe Size of Schema Query Parameters and Literals .............................................................128
LimitResults Per Fetch .....................................................................................................................128
Index ...................................................................................................................................................129
Contents
7