译者序 1
作者简介 1
致谢 1
引言 1
第一部分 数据类型 1
Bfile 1
Binary 1
Bit 1
Blob 2
Character 3
Byte 3
Clob 4
Counter 5
Currency 5
Date 5
Datetime 6
Dbclob 6
Decimal 7
Double Precision 8
Float 9
Guid 10
Identity 10
Graphic 10
Image 11
Integer 11
Interval 12
Long 12
Long Raw 13
Long Varchar 13
Long Vargraphic 13
Longbinary 14
Memo 14
Nchar 15
Mlslabel 15
Money 15
Nclob 16
Number 16
Numeric 17
Nvarchar 18
Raw 19
Real 19
Serial 20
Short 20
Shortdatetime 21
Single 21
Smallint 22
Smalldatetime 22
Text 23
Smallmoney 23
Time 24
Timestamp 24
Tinyint 24
Varbit 25
Varbinary 25
Varchar 26
Vargraphic 27
* 28
/ 28
+ 28
- 28
第二部分 操作符、函数和变量 28
= 29
< 29
<= 29
> 30
>= 30
<> 30
0.000000ound 31
316sopen 31
() 31
%rowcount 32
%rowtype 32
%type 32
‖ 32
Abs 33
Acos 33
And 33
Ascii 33
Avg 34
Atan2 34
Atan 34
Asin 34
Between 36
Bit_length 37
Blob 38
Case 38
Cast 39
Ceiling 40
Char 40
Chr 41
Character_length 41
Concat 42
Collchar 42
Coalesce 42
Clob 42
@@Connections 43
Convert 43
Cos 43
Cosh 43
Cot 44
Count 44
@@Cpu_busy 45
Current Explain Snapshot 46
Current Explain Mode 46
Current Degree 46
Current_date 46
Current Date 46
Current Function Path 47
Current Node 47
Current Qucry Optimization 47
Current Server 48
Current Time 48
Current _time 48
Current Timestamp 48
Current_timestamp 48
Date 49
@@Curosr_rows 49
Current_user 49
Current Timezone 49
@@Datefirst 50
Day 50
Dayname 50
Dayofweek 51
Dayofyear 51
Days 51
Dbblobbuf 52
Dbdate 52
Dbclob 52
Dbapicofe 52
Dbansiwarn 52
Dbdelimiter 53
Dbedit 53
Dblang 54
Dbmoney 54
Dbnls 54
Dbpath 54
Dbspacetemp 55
Dbtime 55
Degrees 56
Decimal 56
Dbupspace 56
@@Dbts 56
Dlimident 57
Difference 57
Digits 57
Double 57
@@Error 58
Event_mon_state 58
Exists 58
Fet_buf_size 59
@@Fetch_status 59
Extract 59
Exp 59
Float 60
Floor 60
Generate_unique 61
Graphic 61
Hex 61
Hextoraw 62
Hour 62
@@Identity 62
@@Idle 62
In 62
Informixcontime 63
Informixconretry 63
Informixdir 64
Informixserver 64
Informixstacksize 64
Informixserver 64
Insert 64
Integer 65
@@Io_busy 65
Julian_day 65
Lc_collate 66
@@Language 66
@@Langid 66
Lang 66
Lc_ctype 67
Lc_monetary 67
Lc_numeric 68
Lc_time 68
Lcase 68
Left 69
Length 70
Like 70
Locate 71
Log10 72
Long_varchar 72
Log 72
Long_vargraphic 73
Lower 73
Ltrim 73
Max 73
@@Max_connections 74
@@Max_precision 74
Microsecond 74
@@Microsoftversion 74
Min 75
Minute 75
Midnight_seconds 75
Mod 76
Month 76
Monthname 76
@@Nestlevel 76
Nodefdac 77
Nodenumber 77
Not 77
Null 77
Nullif 78
Octet_length 78
@@Packet_errors 79
@@Pack_sent 79
Or 79
Onconfig 79
@@Pack_received 79
Partition 80
Path 80
Pi 80
Position 80
Posstr 80
Quarter 81
Radians 81
@@Procid 81
Power 81
Raise_error 82
Rand 82
Real 82
@@Remserver 83
Repeat 83
Replace 83
Right 84
Round 84
@@Rowcount 84
Rtrim 84
Sign 85
Session_user 85
Second 85
@@Servername 85
Sin 86
Sinh 86
Smallint 86
Soundex 86
Space 87
@@Spid 88
Sqrt 88
Substr 88
Substring 88
Sum 89
System_user 90
Table_name 90
Table_schema 91
Tan 91
Tanh 91
@@Textsize 91
Time 92
Timestamp 92
Timestamp_iso 92
Timestampdiff 93
@@Timeticks 93
To_char 94
To_date 96
To_multi_byte 99
To_number 99
To_single_byte 99
Translate 99
Translate 99
Trim 100
@@Total_errors 100
@@Total_read 100
@@Total_write 100
Ucase 101
Upper 101
@@Trancount 101
Truncate 101
User 102
Value 102
Varchar 102
Vargraphic 102
@@Version 103
Week 103
Year 103
Alter Cluster 104
Alter Bufferpool 104
第三部分 语句 104
Alter Database 106
Alter Function 109
Alter Index 109
Alter Nodegroup 113
Alter Procedure 113
Alter Table 114
Alter Tablespace 123
Alter Trigger 126
Call 127
Begin Declare Section 127
Alter View 127
Close 128
Comment On 128
Commit 130
Connect 130
Create Bufferpool 131
Create Cluster 132
Create Controlfile 133
Create Database 134
Create Default 137
Create Distinct Type 137
Create Event Monitor 138
Create Function 139
Create Index 143
Create Nodegroup 147
Create Procedure 147
Create Rule 151
Create Schema 151
Create Synonym 152
Create Table 153
Create Tablespace 160
Create Trigger 164
Create View 167
Create Cursor 168
Delete 168
Describe 169
Disconnect 169
Drop Bufferpool 169
Drop Cluster 169
Drop Database 170
Drop Default 170
Drop Distinct Type 170
Drop Event Monitor 170
Drop Index 171
Drop Nodegroup 171
Drop Function 171
Drop? 172
Drop Rule 172
Drop Schema 172
Drop Synonym 172
Drop Table 172
Drop Tablespace 173
Drop Trigger 173
Drop View 173
End Declare Section 173
Execute Procedure 174
Execute 174
Fetch 175
Flush 176
Free 176
Free Locator 176
Grant 176
Include 178
Info 179
Insert 179
Lord Form 180
Lock Table 181
Open 181
Prepare 182
Output 182
Put 183
Raiserror 183
Recover 184
Release 184
Rename Column 185
Rename Database 185
Rename Table 185
Revoke 185
Rollback 187
Select 188
Setuser 195
Set Connection 195
Singal Sqlstate 196
Start Violations Table 196
Stop Violation Table 197
Truncate Table 197
Unlock Table 197
Update 197
Update Statistics 199
Use 200
Values 200
Whenever 201
附录 创建例子数据库 202