1.1.1

NoteSQL-2003
Optional
SQL-99
Outside
Core
Feature nameFeature
ID
expression> for expressions of type
CHARACTER LARGE OBJECT –
Subclause 6.27, "<numeric value
function>": The <octet length
expression> for expressions of type
BINARY LARGE OBJECT and
CHARACTER LARGE OBJECT –
Subclause 6.29, "<string value
function>": The <fold> function for
expressions of type CHARACTER
LARGE OBJECT – Subclause 6.29,
"<string value function>": The <trim
function> for expressions of type
CHARACTER LARGE OBJECT –
Subclause 6.29, "<string value
function>": The <blob trim function>
-- Subclause 6.29, "<string value
function>": The <character substring
function> for expressions of type
CHARACTER LARGE OBJECT –
Subclause 6.29, "<string value
function>": The <blob substring
function>
YesYesConcatenation of LOB data types –
Subclause 6.28, "<string value
T041-04
expression>": The <concatenation>
expression for expressions of type
CHARACTER LARGE OBJECT –
Subclause 6.28, "<string value
expression>": The <blob
concatenation> expression
NoNoLOB locator: non-holdable –
Subclause 13.3,
T041-05
"<externally-invoked procedure>":
<locator indication> -- Subclause
14.14, "<free locator statement>"
CAST and string value functions implemented.
No comparision or ordering.
PartialPartialExtended LOB data type supportT042
NoNoRow typesT051
NoN/AMAX and MIN for row typesT052
NoN/AExplicit aliases for all-fields
reference
T053
NoN/AUCS supportT061
YesN/ABIGINT data typeT071
vFabric SQLFire User's Guide650
vFabric SQLFire Reference