SYSRESULTSET

From Recital Documentation Wiki
Revision as of 16:40, 9 December 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

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

EXEC SQL
set("EXCLUSIVE") as Excl, time() as Time from sysresultset;


Products

Recital, Recital Server