Datatid 1999 #6/Datatid_1999-06.iso/internet/Tango352Promo/P.SQL/DOC/WESQL/SQLREF.CNT

Microsoft Windows Help File Content | 1998-08-10 | 6.9 KB | 203 lines

:Base sqlref.hlp
:Title sqlref
#{\footnote sqlref_cnt_1592}
{\fs18 Contents \par }
1 About This Manual
2 Who Should Read This Manual=about_rtf_4594
2 Manual Organization=about_rtf_4449
2 Conventions=about_rtf_3813
1  1 SQL Overview
2 Data Definition Statements
3 Creating and Deleting Dictionaries=sqlintro_rtf_7475
3 Creating, Modifying, and Deleting Tables=sqlintro_rtf_3573
3 Defining Column Attributes=sqlintro_rtf_3588
3 Creating and Deleting Indexes=sqlintro_rtf_3619
3 Creating and Deleting Triggers=sqlintro_rtf_5601
2 Data Manipulation Statements
3 Retrieving Data=sqlintro_rtf_3649
3 Modifying Data=sqlintro_rtf_3686
3 Defining Transactions=sqlintro_rtf_3703
3 Creating and Deleting Views=sqlintro_rtf_3723
3 Creating, Deleting, and Executing Stored Procedures=sqlintro_rtf_3734
2 Data Control Statements
3 Enabling and Disabling Security=sqlintro_rtf_3769
3 Creating and Deleting Users and Groups=sqlintro_rtf_3777
3 Granting and Revoking Rights=sqlintro_rtf_3797
2 Data Administration Statements=sqlintro_rtf_3819
2 Data File Paths
3 Database Names=sqlintro_rtf_4396
3 Path Strings=sqlintro_rtf_4410
1  2 Scalable SQL Syntax
2 Comments in SQL Statements=sqlsyntx_rtf_36452
2 ALTER TABLE
3 IN DICTIONARY=sqlsyntx_rtf_1985
3 USING=sqlsyntx_rtf_1989
3 WITH REPLACE=sqlsyntx_rtf_2081
3 ADD=sqlsyntx_rtf_1997
3 MODIFY=sqlsyntx_rtf_2023
3 DROP=sqlsyntx_rtf_15674
2 BEGIN...END (compound statement)
3 Rules for Creating Compound Statements=sqlsyntx_rtf_12548
2 CALL
3 Rules for Using the CALL Statement=sqlsyntx_rtf_10757
2 CLOSE (cursor)=sqlsyntx_rtf_6626
2 COMMIT WORK
3 Rules for Using the COMMIT WORK Statement=sqlsyntx_rtf_7083
2 CREATE DICTIONARY=sqlsyntx_rtf_6589
2 CREATE GROUP=sqlsyntx_rtf_2061
2 CREATE INDEX
3 Index Columns and Attributes=sqlsyntx_rtf_2085
3 Alternate Collating Sequence=sqlsyntx_rtf_2094
2 CREATE PROCEDURE
3 Rules for Creating Stored Procedures=sqlsyntx_rtf_5588
3 Parameters of Stored Procedures=sqlsyntx_rtf_33681
2 CREATE TABLE
3 Defining the Data File Location=sqlsyntx_rtf_12870
3 Specifying Data File Options=sqlsyntx_rtf_2226
3 WITH REPLACE=sqlsyntx_rtf_2241
3 Defining Columns=sqlsyntx_rtf_2245
3 Defining the Primary Key=sqlsyntx_rtf_2261
3 Defining Foreign Keys=sqlsyntx_rtf_2267
3 Defining Indexes=sqlsyntx_rtf_2287
2 CREATE TRIGGER
3 Rules for Creating Triggers=sqlsyntx_rtf_12664
3 Invoking a Trigger=sqlsyntx_rtf_14915
3 Examples=sqlsyntx_rtf_20712
2 CREATE VIEW
3 Column Headings=sqlsyntx_rtf_2328
3 ReadOnly Views=sqlsyntx_rtf_2333
2 DECLARE (variable)
3 Rules for Declaring a SQL Variable=sqlsyntx_rtf_11017
2 DECLARE CONDITION
3 Rules for Declaring Conditions=sqlsyntx_rtf_10528
2 DECLARE CURSOR
3 Rules for Declaring Cursors=sqlsyntx_rtf_11146
2 DECLARE HANDLER
3 Rules for Declaring Handlers=sqlsyntx_rtf_10545
2 DELETE=sqlsyntx_rtf_6368
2 DELETE: positioned
3 Rules for Using the Positioned DELETE Statement=sqlsyntx_rtf_11589
2 DROP DICTIONARY=sqlsyntx_rtf_6373
2 DROP GROUP=sqlsyntx_rtf_2365
2 DROP INDEX=sqlsyntx_rtf_2373
2 DROP PROCEDURE=sqlsyntx_rtf_2384
2 DROP TABLE=sqlsyntx_rtf_2392
2 DROP TRIGGER=sqlsyntx_rtf_2402
2 DROP VIEW=sqlsyntx_rtf_7020
2 FETCH
3 Rules for Using the FETCH Statement=sqlsyntx_rtf_11399
2 GRANT (access rights)
3 All Right=sqlsyntx_rtf_2447
3 Insert Right=sqlsyntx_rtf_2450
3 Delete Right=sqlsyntx_rtf_2456
3 Alter Right=sqlsyntx_rtf_2459
3 References Right=sqlsyntx_rtf_2464
3 Select Right=sqlsyntx_rtf_2469
3 Update Right=sqlsyntx_rtf_2476
2 GRANT CREATETAB=sqlsyntx_rtf_2482
2 GRANT LOGIN=sqlsyntx_rtf_2493
2 IF=sqlsyntx_rtf_6679
2 INSERT
3 VALUES Clause=sqlsyntx_rtf_2523
3 SELECT Clause=sqlsyntx_rtf_13168
2 LEAVE
3 Rules for Using the LEAVE Statement=sqlsyntx_rtf_6739
2 LOOP=sqlsyntx_rtf_6716
2 OPEN (cursor)
3 Rules for Opening a Cursor=sqlsyntx_rtf_6159
2 RELEASE SAVEPOINT=sqlsyntx_rtf_7061
2 RESIGNAL
3 Rules for Using the RESIGNAL Statement=sqlsyntx_rtf_10604
2 REVOKE (access rights)=sqlsyntx_rtf_6095
2 REVOKE CREATETAB=sqlsyntx_rtf_2563
2 REVOKE LOGIN=sqlsyntx_rtf_2570
2 ROLLBACK WORK
3 Rules for Using the ROLLBACK WORK Statement=sqlsyntx_rtf_7087
2 SAVEPOINT
3 Rules for Creating Savepoints=sqlsyntx_rtf_7048
2 SELECT
3 DISTINCT=sqlsyntx_rtf_2600
3 Select List=sqlsyntx_rtf_31252
3 AS=sqlsyntx_rtf_31846
3 FROM=sqlsyntx_rtf_31900
3 WHERE=sqlsyntx_rtf_2619
3 GROUP BY=sqlsyntx_rtf_2695
3 HAVING=sqlsyntx_rtf_13976
3 ORDER BY=sqlsyntx_rtf_2733
3 Group Aggregate Functions=sqlsyntx_rtf_2765
3 Combining Multiple Queries with UNION=sqlsyntx_rtf_2808
3 Read-Only Views=sqlsyntx_rtf_24918
2 SET=sqlsyntx_rtf_2920
2 SET CHAR=sqlsyntx_rtf_2930
2 SET DATAPATH=sqlsyntx_rtf_2940
2 SET DATEFORMAT=sqlsyntx_rtf_21060
2 SET DEFAULT=sqlsyntx_rtf_31698
2 SET (global null value)=sqlsyntx_rtf_2950
2 SET ISOLATION=sqlsyntx_rtf_2962
2 SET MASK=sqlsyntx_rtf_31194
2 SET OPENMODE
3 Normal Mode=sqlsyntx_rtf_2997
3 Accelerated Mode=sqlsyntx_rtf_2998
3 ReadOnly Mode=sqlsyntx_rtf_21133
3 Verify Mode=sqlsyntx_rtf_3004
3 Exclusive Mode=sqlsyntx_rtf_3006
2 SET OWNER=sqlsyntx_rtf_3011
2 SET RANGE=sqlsyntx_rtf_3021
2 SET SECURITY=sqlsyntx_rtf_3032
2 SET VALUES=sqlsyntx_rtf_3042
2 SIGNAL
3 Rules for Using the SIGNAL Statement=sqlsyntx_rtf_11369
2 START TRANSACTION=sqlsyntx_rtf_3052
2 UPDATE
3 Specifying Data Values Directly=sqlsyntx_rtf_3077
3 Extracting Data Values with a SELECT Clause=sqlsyntx_rtf_3091
2 UPDATE: positioned
3 Rules for Using the Positioned UPDATE Statement=sqlsyntx_rtf_6493
2 WHILE=sqlsyntx_rtf_6444
1  A Data Types
2 FixedLength Data Types
3 AUTOINC=sqldtype_rtf_3087
3 BFLOAT=sqldtype_rtf_4101
3 BIT=sqldtype_rtf_3113
3 CHARACTER=sqldtype_rtf_3124
3 CURRENCY=sqldtype_rtf_4035
3 DATE=sqldtype_rtf_4021
3 DECIMAL=sqldtype_rtf_11941
3 FLOAT=sqldtype_rtf_3173
3 INTEGER=sqldtype_rtf_3189
3 LOGICAL=sqldtype_rtf_3196
3 LSTRING=sqldtype_rtf_3199
3 MONEY=sqldtype_rtf_3212
3 NUMERIC=sqldtype_rtf_12282
3 NUMERICSA=sqldtype_rtf_3321
3 NUMERICSTS=sqldtype_rtf_3387
3 TIME=sqldtype_rtf_3403
3 TIMESTAMP=sqldtype_rtf_4082
3 UNSIGNED=sqldtype_rtf_4061
3 ZSTRING=sqldtype_rtf_4936
2 VariableLength Data Types
3 LVAR=sqldtype_rtf_3442
3 NOTE=sqldtype_rtf_11463
1  B Scalable SQL Keywords
2 List of Keywords=sqlkword_rtf_9248
1  C System Tables
2 Installing System Tables and Data Dictionary Files=sqlsystb_rtf_3207
2 X$File=sqlsystb_rtf_3216
2 X$Field=sqlsystb_rtf_3317
2 X$Index=sqlsystb_rtf_3519
2 X$Attrib=sqlsystb_rtf_3716
2 X$View=sqlsystb_rtf_3807
2 X$Proc=sqlsystb_rtf_3898
2 X$User=sqlsystb_rtf_3993
2 X$Rights=sqlsystb_rtf_4147
2 X$Relate=sqlsystb_rtf_4349
2 X$Trigger=sqlsystb_rtf_821
2 X$Depend=sqlsystb_rtf_6356
1  D SQLSTATE Classes and Values
2 Example Use of SQLSTATE=sqlstate_rtf_17766
2 Types of SQLSTATE Values=sqlstate_rtf_17758
2 SQLSTATE Classes=sqlstate_rtf_23070
2 SQLSTATE Subclasses=sqlstate_rtf_23667
2 Application-Defined SQLSTATE Values=sqlstate_rtf_23740
2 SQLSTATE Values=sqlstate_rtf_17444