View source for SYSRESULTSET

==Purpose==
Used to return the singleton result from any Recital expression


==See Also==
[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|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.


{| class="wikitable"
!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==
<code lang="recital">
EXEC SQL
set("EXCLUSIVE") as Excl, time() as Time from sysresultset;
</code>


==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
[[Category:Documentation]]
[[Category:SQL]]
[[Category:System Tables]]