Difference between revisions of "SET PAUSE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Recital Terminal Developer Environment
 
 
 
 
==Purpose==
 
==Purpose==
 
Enable or disable screen pauses for the Recital/SQL SELECT statement
 
Enable or disable screen pauses for the Recital/SQL SELECT statement
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[DISPLAY]], [[Function Keys]], [[LIST]], [[SET SQL]]
+
[[DISPLAY]], [[Function Keys]], [[LIST]], [[SET SQL]], [[SET SQLPROMPT]]
  
  
Line 29: Line 25:
  
 
==Products==
 
==Products==
Recital Terminal Developer
+
Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|PAUSE]]
 
[[Category:Set_Commands|PAUSE]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 +
[[Category:SQL Set Commands]]
 +
[[Category:Terminal Environment]]
 +
[[Category:Terminal Environment Set Commands]]

Latest revision as of 16:34, 23 November 2009

Purpose

Enable or disable screen pauses for the Recital/SQL SELECT statement


Syntax

SET PAUSE ON | OFF | (<expL>)


See Also

DISPLAY, Function Keys, LIST, SET SQL, SET SQLPROMPT


Description

The SET PAUSE ON command causes the Recital/SQL SELECT command to pause after every screen of output until a key is pressed to continue, or the [ABANDON] key is pressed to cancel. When SET PAUSE is off, records retrieved with the Recital/SQL SELECT command scroll continuously until the last record is displayed.


Example

use accounts
set pause on
set sql on
select * from accounts;


Products

Recital