SYSRESULTSET
From Lianjapedia
Revision as of 11:57, 22 December 2009 by Yvonnemilne (Talk)
Contents
Purpose
Used to return the singleton result from any Recital expression
See Also
DATA TYPES, SELECT, SYSTEM TABLES
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
The SYSRESULTSET system table is used to return the singleton result from any Recital expression.
Column | Data Type | Width |
---|---|---|
<expression1> | <result1 type> | <result1 width> |
… | … | … |
<expression256> | <result256 type> | <result256 width> |
An error will occur if any expression is specified that returns more than one result.
Example
select set("EXCLUSIVE") as Excl, time() as Time from sysresultset
Products
Recital, Recital Server