HP c-tree-SQL ISQL and Tools Manuale Utente Scaricare il pdf (Pagina 54)

ISQL and Tools

3-28 FairCom Corporation

( orders.order_id = lots.order_id ) and

( ( customers.customer_name = 'Ship Shapers Inc.' ) AND

( lot_staging.start_date is not NULL ) AND

( lot_staging.end_date is NULL ) )

ISQL> RUN

SELECT customers.customer_name,

orders.order_info,

orders.order_state,

lot_staging.lot_location,

lot_staging.start_date

FROM customers,

orders,

lots,

lot_staging

WHERE ( customers.customer_id = orders.customer_id ) and

( lots.lot_id = lot_staging.lot_id ) and

( orders.order_id = lots.order_id ) and

( ( customers.customer_name = 'Ship Shapers Inc.' ) AND

( lot_staging.start_date is not NULL ) AND

( lot_staging.end_date is NULL ) )

1 2 ... 49 50 51 52 53 54 55 56 57 58 59 ... 98 99

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

Commenti su questo manuale

Nessun commento

HP c-tree-SQL ISQL and Tools Manuale Utente Pagina 54

Commenti su questo manuale

Prodotti e manuali riguardandi Software HP c-tree-SQL ISQL and Tools