譯者序 作者簡介 致謝 引言 第一部分 數(shù)據(jù)類型 Bfile Binary Bit Blob Byte Character Clob Counter Currency Date Datetime Dbclob Decimal Double Precision Float Graphic Guid Identity Image Integer Interval Logn Logn Raw Logn Varchar Logn Vargraphic Longbinary Memo Money Mlslabel Nchar Nclob Number Numeric Nvarchar Raw Real SErial Short Shortdatetime Single Smaldatetime Smallint Smallmoney Text Time Timestampo Tinyint Varbit Varbinary Varchar Vargraphic 第二部分 操作符、函數(shù)和變量 + - * / = < <= > >= <> () %found %isopen %rowcount %rowtype %type || Abs Acos And Ascii Asin Atan Atan2 Avg Between Bit_length Blob Case Cast Ceiling Char Chr Character_Length Clob Coalesce Collchar Concat @@Connections Convert Cos Cosh Cot Count @@Cpu_busy Current Data Current_date Current Degree current Explain Mode Current Explain Snapshot Currnet Function Path Current Node Current Query Optimizartion Currnet Server Current Time Currnet_Time Current Timstamp Current Timezone Current_User @@Cursor_rows Date @@Datefirst Day Dayname Dayofweek Dayofyear Days Dbaniwarn Dbapicode Dbblobbuf Dbclob Dbdate Dbdelimiter Dbedit Dblang Dbmoney Dbnls Dbpath Dbspacetemp Dbtime @@Dbts Dbupspace Decimal Dergress Delimident Difference Digits Double @@Error Envent_mon_state Exists Exp Extract Fet_buf_size @@Fetch_status Float Floor Generate_unique Graphic Hex Hextoraw Hour @@Identity @@Idle In IHformixconretry Informixcontime Informixdir Informixstacksize Informixserver Insert Intger @@Io_busy Julian_day Lang @@Langid @@Language Lc_collate Lc_ctype Lc_monetary Lc_numeric Lc_time Lcase Left Length Like Locate Log Log10 Log_varchar Logn_vargraphic Lower Ltrim Max @@Max_connections @@Max_precision Microsecond @@Microsoftversion Midnight_seconds Min Minute Mod Month Monthname @@Nestlevel Nodef\dac Nodenumber Not Null Nulif Octet_Length Onconfig Or @@Pack_received @@Pack_sent @@Packet_srrors Partition path Pi Position Posstr Power @@Procid Quarter Radians Raise_error Rand Real @@Remserver Repeat Replace Right Round @@Rowcount Rtim Second @@SErvername Session_use Sign Sin Sinh Smallint Soundex Space @@Spid Sqrt Substr Substring Sum System_user Table_name Table_schema Tan Tanh @@Textsize Time Tjimestamp Timestamp_iso Timestampdiff @@Timeticks To_char To_date To_multi_byte To_number To_single_byte Translate Translate Trim @@Total_errors @@Total_read @@Total_write @@Trancount Truncate Ucase Upper User Value Varchar Vargraphic @@Version Week Yewr 第三部分 語句 Alter Bufferpool Alter Cluster Alter Database Alter Function Alter Index Alter Nodegroup Alter Procedure Alter Table Alter Tablespace Alter Trigger Alter View Begin Declare SEction Begin Work Call Close Comment On Commit Connect Create Bufferpool Create Cluster Create Controlfile Create Database Create Default Create Distinct Type Create Event Monitor Create Function Create Index Create Nodegroup Create Procedure Create Rule Create Schema Create Synonym Create Table Create Tablespace Create Trigger Create View Create Cursor Delete Describe Disconnect Drop Bufferpool Drop Cluster Drop Database Drop Default Drop Distinct Type Drop Event Monitor Drop Function Drop Index Drop Nodegroup Drop Package Drop Procedure Drop Rule Drop Schema Drop Synonym Drop Table Drop Tablespace Drop Trigger Drop View End Declare Section Execute Execute Procedure Fetch Flush Free Free Locator Grant Include Info Insert Lord Form Lock Table Open Output Prepare Put Raiserror Recover Release Rename Column Rename Database Renmae Table Revoke Rollback Select Set Connection Setuser Shutdown Signal Sqlstate STart Violations Table Stop Violation Table Truncate Table Unlock Table Update Update Statistics Use Values Whenever 附錄 創(chuàng)建例子數(shù)據(jù)庫