HP c-tree-SQL ISQL and Tools User Manual Page 39
- Page / 99
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
ISQL Statements
FairCom Corporation 3-13
insert into stores values (1001,chassis);
insert into stores values (1002,chips);
select * from stores where item_no > 1001;
set echo off ;
To execute the above statements stored in a file named cmdfile, enter:
ISQL> @cmdfile
3.7.2 BREAK
Syntax
BREAK [ ON break_spec [ SKIP n ] ] ;
break_spec::
{ column_name [ , … ] | ROW | PAGE | REPORT }
Description
The BREAK statement specifies at what point ISQL processes associated DISPLAY and
COMPUTE statements. DISPLAY and COMPUTE statements have no effect until you issue a
BREAK statement with the same break specification.
A break can be specified on any of the following events:
• Change in the value of a column
• Selection of each row
• End of a page
• End of a report
Only one BREAK statement can be in effect at a time. When a new BREAK statement is
entered, it replaces the previous BREAK statement. The BREAK statement can specify one or
more columns on which the break can occur.
The BREAK statement without any clauses displays the currently-set break, if any.
Arguments
break_spec
The events that cause an SQL query to be interrupted and the execution of the associated
COMPUTE and DISPLAY statements. break_spec can be any of the following values:
column_name Causes a break when the value of the column specified by
column_name changes.
ROW Causes a break on every row selected by a SELECT statement.
- For use with c-treeSQL Server 1
- Table of Contents 3
- 4 Data Load Utility: dbload 4
- Documentation Overview 7
- RELATED DOCUMENTATION 8
- Chapter 1 9
- Introduction 9
- ISQL and Tools 10
- 1-2 FairCom Corporation 10
- Chapter 2 11
- Quick Tour 11
- 2.1.2 Define 12
- 2.1.3 Manage 12
- Add Records 12
- Delete Records 13
- 2.1.4 Done 13
- Display Records 13
- TUTORIAL 14
- 2.2.3 Manage 16
- 2.2.4 Done 17
- Tutorial Source Code 18
- 2.3 LOCKING TUTORIAL 19
- 2.3.2 Define 20
- 2.3.3 Manage 20
- Update Record 21
- 2.3.4 Done 21
- 2-12 FairCom Corporation 22
- Appendix A " 22
- Tutorial Source Code" 22
- 2.4.1 Init 23
- 2.4.2 Define 23
- Transaction 24
- 2.4.3 Manage 25
- 2.4.4 Done 26
- Source Code 26
- ISQL Statements 27
- 3.3 STATEMENT HISTORY SUPPORT 28
- FairCom Corporation 3-3 29
- 3.6 TRANSACTION SUPPORT 37
- 3.7 ISQL REFERENCE 38
- 3.7.2 BREAK 39
- Description 39
- Arguments 39
- Examples 40
- 3.7.3 CLEAR 41
- Argument 42
- 3.7.4 COLUMN 42
- (a) Format String Details 44
- 3.7.5 COMPUTE 47
- 3.7.8 EDIT 51
- 3.7.9 EXIT or QUIT 52
- Related Statements 52
- 3-28 FairCom Corporation 54
- 3.7.13 HOST or SH or ! 57
- 3.7.14 LIST 58
- 3.7.19 SHOW 63
- 3.7.20 SPOOL 64
- 3.7.22 TABLE 66
- FairCom Corporation 3-41 67
- 3.7.23 TITLE 68
- 3-44 FairCom Corporation 70
- Data Load Utility: dbload 71
- 4.2 PREREQUISITES FOR DBLOAD 72
- 4.4 DATA FILE FORMATS 73
- 4.5 THE COMMANDS FILE 74
- 4.5.2 The FOR EACH Statement 76
- 4.6 EXAMPLES 77
- 4.7 DBLOAD ERRORS 78
- 4.7.2 Fatal Errors 79
- 4-10 FairCom Corporation 80
- Data Unload Utility: dbdump 81
- 5.4 DATA FILE FORMATS 82
- 5.5 THE COMMANDS FILE 82
- 5.6 EXAMPLES 84
- 5-6 FairCom Corporation 86
- Chapter 6 87
- 6.2 EXAMPLES 88
- 6-4 FairCom Corporation 90
- Appendix A 91
- A-2 FairCom Corporation 92
- A.3 LOCKING TUTORIAL 93
- A-4 FairCom Corporation 94
- FairCom Corporation A-5 95
- A-6 FairCom Corporation 96
Related products and manuals for Software HP c-tree-SQL ISQL and Tools
Software HP XP512 User Manual
(99 pages)
(99 pages)
Software HP XP10000 User's Guide
(109 pages)
(109 pages)
Software HP NetMail/3000 User Manual
(102 pages)
(102 pages)
Software HP Moonshot-45G User Manual
(76 pages)
(76 pages)
Software HP T5300 User Manual
(338 pages)
(338 pages)
Software HP X9320 User's Guide
(150 pages)
(150 pages)
Software HP 48gII User Manual
(175 pages)
(175 pages)
Software HP B6191-90029 User Manual
(140 pages)
(140 pages)
Software HP 250m White Paper
(95 pages)
(95 pages)
Software HP 5992-3838 User Manual
(78 pages)
(78 pages)
Software HP XP20000 User Manual
(170 pages)
(170 pages)
Software HP sa3110 Quick Start Guide
(46 pages)
(46 pages)
Software HP 2TB User Manual
(84 pages)
(84 pages)
Software HP SVS200 User Manual
(219 pages)
(219 pages)
Software HP 11i User Manual
(557 pages)
(557 pages)
Software HP Integrated Lights-Out User Manual
(410 pages)
(410 pages)
Software HP IA-64 User Manual
(110 pages)
(110 pages)
Software HP 3PAR User Manual
(475 pages)
(475 pages)
Lensbaby Composer Pro w/ Sweet 50 manuels
Manuels d'utilisation et guides de l'utilisateur pour Objectifs d'appareil photo Lensbaby Composer Pro w/ Sweet 50.
Nous fournissons des manuels en pdf 1 Lensbaby Composer Pro w/ Sweet 50 à télécharger gratuitement par type de document : Manuel de l'utilisateur
Comments to this Manuals