SQLstream does not implement the following transactional operations:
Operation | Notes |
---|---|
COMMIT | Not relevant for stream processing |
ROLLBACK | Not relevant for stream processing |
SAVEPOINT | Not relevant for stream processing |
SET TRANSACTION | Not relevant for stream processing |
START TRANSACTION | Not relevant for stream processing |
SQLstream does not implement the following the SQL standard data types:
Type | Notes |
---|---|
Large object types | BINARY LARGE OBJECT (BLOB), CHARACTER LARGE OBJECT (CLOB), NATIONAL CHARACTER LARGE OBJECT (NCLOB) |
MULTISET | NATIONAL CHARACTER LARGE OBJECT (NCLOB), NATIONAL CHARACTER VARYING (NCHAR VARYING) |
Reference types | Subtables, Supertables, Typed tables |
Timezones | TIME WITH TIMEZONE, TIMESTAMP WITH TIMEZONE |
Year-month INTERVAL | Day-time INTERVAL is supported |
BIT | BIT VARYING |
Where SQLstream does not implement a data type, it also does not implement functions defined by the SQL standard that return a value of that type:
Type | Unsupported functions |
---|---|
Timezones | CURRENT_TIMECURRENT_TIMESTAMP |
Additionally, SQLstream s-Server supports only the single-byte character sets supported by Java. SQLstream does not specifically implement the character repertoire names specified by ISO/IEC 9075, though in some cases equivalent functionality is provided under another name:
ISO/IEC 9075 character repertoire | SQLstream alternative |
---|---|
GRAPHIC_IRV | n/a |
ISO8BIT | n/a |
LATIN1 | ISO-8859-1 |
SQL_CHARACTER | n/a |
SQL_TEXT | n/a |
SQL-IDENTIFIER | n/a |
UTF8 | n/a |
UTF16 | n/a |
UTF32 | n/a |
Unimplemented the SQL standard functions and operators
SQLstream does not support the following the SQL standard functions and operators:
Function/Operator Type | Keywords |
---|---|
Numeric functions | CARDINALITY, OCTET_LENGTH, SQRT, WIDTH_BUCKET |
Aggregate/Analytic functions | ANY, COLLECT, COVAR_POP, COVAR_SAMP, CORR, CUME_DIST, DENSE_RANK, ELEMENT, EVERY, FUSION, INTERtopic, MEMBER OF, PERCENT_RANK, PERCENTILE_CONT, PERCENTILE_DISC, RANK, REGR_AVG, XREGR_AVGY, REGR_COUNT, REGR_INTERCEPT, REGR_R2, REGR_SLOPE, REGR_SXX, REGR_SYY, REGR_SXY, ROW_NUMBER, SOME,SUBMULTISET OF,UNNEST |
String value functions | CONVERT, TRANSLATE, NORMALIZE |
Other unimplemented the SQL standard features
Feature | Notes |
---|---|
Embedded SQL | Includes:ADACCOBOLFORTRANMUMPSPASCALPL/I |
Diagnostics | GET DIAGNOSTICS |