SET SQLROWID

From Recital Documentation Wiki
Revision as of 16:38, 11 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

SET SQLROWID

Class

SQL Applications


Purpose

To include a unique row identifier in SELECT * statements


Syntax

SET SQLROWID ON | OFF


See Also

SELECT, UNIQUEROWID()


Description

The SET SQLROWID ON | OFF command is used to determine whether a unique row identifier in should be included in SELECT * statements. If SET SQLROWID is ON, the unique row identifier will be included, if SET SQLROWID is OFF, only the fields from the table will be included.


Example

set sql on
set sqlrowid on
select * from state.rdb where state = "M";


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer