Difference between revisions of "SYSRESULTSET"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 30: | Line 30: | ||
|- | |- | ||
|} | |} | ||
| + | |||
An error will occur if any expression is specified that returns more than one result. | An error will occur if any expression is specified that returns more than one result. | ||
Revision as of 12:08, 13 March 2009
SYSRESULTSET
Class
SQL Applications
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 Database Server, Recital Mirage Server, Recital Terminal Developer
