Difference between revisions of "SYSRESULTSET"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 11: | Line 11: | ||
==See Also== | ==See Also== | ||
| − | [[DATA TYPES]], [[SQL SELECT|SELECT]], [[SYSTEM TABLES]] | + | [[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]] |
Revision as of 16:03, 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
