Table of Contents

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] data      retrieving          ADO.NET          JDBC Data Control Language (DCL) Data Definition Language (DDL) Data Manipulation Language (DML) data structures database objects and operators 2nd database programming [See programming databases] DATABASE( ) function (MySQL) DATABASEPROPERTYEX function      SQL Server DATALENGTH function (SQL Server) DATALINK datatype      DB2      platform comparison DataReader methods (ADO.NET)      Get datatypes      DB2      MySQL      Oracle      PostgreSQL      SQL Server      Sybase adaptive server DATE datatype      DB2      MySQL      Oracle      platform comparison      PostgreSQL DATE function (DB2) DATE_ FORMAT function (MySQL) DATE_ADD function (MySQL) DATE_PART function (PostgreSQL) DATE_SUB function (MySQL) DATE_TRUNC function (PostgreSQL) DATEADD function (SQL Server) DATEDIFF function (SQL Server) DATENAME function (SQL Server) DATEPART function (SQL Server) DATETIME datatype      MySQL      platform comparison      PostgreSQL      SQL Server 2nd      Sybase adaptive server DateTime parameter object type (ADO.NET) DAY function      DB2      SQL Server DAYNAME function      DB2      MySQL DAYOFMONTH function (MySQL) DAYOFWEEK function      DB2      MySQL DAYOFWEEK_ISO function (DB2) DAYOFYEAR function      DB2      MySQL DAYS function (DB2) DB_ACCESSADMIN (SQL Server system role) DB_BACKUPOPERATOR (SQL Server system role) DB_DATAREADER (SQL Server system role) DB_DATAWRITER (SQL Server system role) DB_DDLADMIN (SQL Server system role) DB_DENYDATAREADER (SQL Server system role) DB_DENYDATAWRITER (SQL Server system role) DB_ID function (SQL Server) DB_NAME function (SQL Server) DB_OWNER (SQL Server system role) DB_SECURITYADMIN (SQL Server system role) DB2      allowed characters in identifiers      beginning identifier character      CALL statement      CLOSE CURSOR statement      COMMIT statement      CONNECT statement      connecting using JDBC      CREATE/ALTER DATABASE statements          ALIAS          APPLY          AT DBPARITIONNUM          AUTOCONFIGURE          CATALOG TABLESPACE          COLLATE USING          CREATE {DATABASE | DB}          DFT_EXTENT_SZ          EXTENTSIZE          MANAGED BY          NUMSEGS          ON          OVERHEAD          PREFETCHSIZE          tablespace_definition          TEMPORARY TABLESPACE          TRANSFERRATE          USER TABLESPACE          USING CODESET          WITH      CREATE/ALTER FUNCTION/PROCEDURE statements          CARDINALITY          CONTAINS SQL          DBINFO          EXTERNAL NAME          FENCED          FINAL CALL          INHERIT SPECIAL REGISTERS          LANGUAGE          MODIFIES SQL DATA          NO SQL          PARALLEL          PARAMETER STYLE          PREDICATES          PROGRAM TYPE          READS SQL DATA          RETURNS          SCRATCHPAD          THREADSAFE          TRANSFORM GROUP      CREATE/ALTER INDEX statements          ALLOW REVERSE SCANS          ASC          CLUSTER          COLLECT STATISTICS          DESC          EXTEND USING          INCLUDE          MINPCTUSED          PCTFREE          SPECIFICATION ONLY      CREATE/ALTER METHOD statements      CREATE/ALTER ROLE statements      CREATE/ALTER SCHEMA statements      CREATE/ALTER TABLE statements          ACTIVATE NOT LOGGED INITIALLY          ACTIVATE VALUE COMPRESSION          ADD          ALTER [COLUMN]          ALTER {CHECK | FOREIGN KEY}          APPEND          AS          AS IDENTITY          COMPACT          COMPRESS SYSTEM DEFAULT          copy_options          DATA CAPTURE 2nd          DEFINITION ONLY          derived_table_options          DROP          FILE LINK CONTROL          GENERATED          IN          intermediate table, defining          LIKE          LINKTYPE URL          LOCKSIZE          LOGGED          MODE DB2OPTIONS          NLINE LENGTH          NO LINK CONTROL          NOT LOGGED INITIALLY          OPTIONS          ORGANIZE BY          PARTITIONING KEY          PCTFREE          REPLICATED          SCOPE          SET MATERIALIZED QUERY          UNDER          VALUE COMPRESSION          VOLATILE          WITH RESTRICT ON DROP      CREATE/ALTER TRIGGER statements      CREATE/ALTER TYPE statements          ADD METHOD          ALTER METHOD          DISTINCT          DROP METHOD          FENCED          INLINE LENGTH          METHOD          MODE DB2SQL          OVERRIDING          RESTRICT          THREADSAFE          WITH COMPARISONS          WITHOUT COMPARISONS      CREATE/ALTER VIEW statements          WITH CHECK OPTION clause      datalink-related attributes      datatypes      DECLARE CURSOR command      DELETE statement      DISCONNECT statement      DROP statements          [DISTINCT] TYPE          [SPECIFIC] FUNCTION          [SPECIFIC] METHOD          BUFFERPOOL          DATABASE PARTITION GROUP          EVENT MONITOR          FUNCTION MAPPING          INDEX          NICKNAME          PACKAGE          RESTRICT          SCHEMA          SEQUENCE          SERVER          TABLE          TABLESPACE          TRANSFORM          TRIGGER          TYPE MAPPING          USER MAPPING FOR          VIEW          WRAPPER      EXCEPT set operator      external scalar user-defined functions      external stored procedure      external table user-defined functions      FETCH statement      functions          ABSVAL          ACOS          ASCII          ASIN          ATAN          ATAN2          ATANH          BIGINT          BLOB          CHAR          CHR          CLOB          COALESCE          CONCAT          COS          COSH          COT          DATE          DAY          DAYNAME          DAYOFWEEK          DAYOFWEEK_ISO          DAYOFYEAR          DAYS          DBCLOB          DBPARTITIONNUM          DEC          DECIMAL          DECRYPT_BIN          DECRYPT_CHAR          DEGREES          DEREF          DIFFERENCE          DIGITS          DOUBLE          ENCRYPT          EVENT_MON_STATE          FLOAT          GENERATE_UNIQUE( )          GETHINT          GRAPHIC          HASHEDVALUE          HEX          HOUR          IDENTITY_VAL_LOCAL( )          INSERT          INTEGER          JULIAN_DAY          LEFT          LENGTH          LOCATE          LOG          LOG10          LONG_VARCHAR          LONG_VARGRAPHIC          LTRIM          MICROSECOND          MIDNIGHT_SECONDS          MINUTE          MONTH          MONTHNAME          MULTIPLY_ALT          NULLIF          POSSTR          QUARTER          RADIANS          RAISE_ERROR          RAND          REAL          REC2XML          REPEAT          REPLACE          RIGHT          ROUND          RTRIM          SECOND          SIGN          SIN          SINH          SMALLINT          SOUNDEX          SPACE          STDDEV          SUBSTR          TABLE_NAME          TABLE_SCHEMA          TAN          TANH          TIME          TIMESTAMP          TIMESTAMP_FORMAT          TIMESTAMP_ISO          TIMESTAMPDIFF          TO_CHAR          TO_DATE          TRANSLATE          TRUNC          TRUNCATE          TYPE_ID          TYPE_NAME          TYPE_SCHEMA          VALUE          VAR          VARCHAR          VARCHAR_FORMAT          VARGRAPHIC          VARIANCE          WEEK          WEEK_ISO          YEAR      GRANT statement          {ALTER | USAGE} ON SEQUENCE          {ALTERIN | CREATEIN | DROPIN} ON SCHEMA          {BIND | CONTROL | EXECUTE} ON PACKAGE          CONTROL ON INDEX          database_privileges          EXECUTE ON          object_privilege          PASSTHRU ON SERVER          TO USER          USE OF TABLESPACE          WITH GRANT OPTION      identifier size      INSERT statement      INTERSECT set operator      JOIN subclause      keywords      LDAP      LIKE operator      MERGE statement      OLE-DB external table user-defined functions      OPEN statement      ORDER BY clause      RELEASE SAVEPOINT statement      reserved identifiers      RETURN statement      REVOKE statement          { ALTERIN | CREATEIN | DROPIN } ON SCHEMA          { BIND | CONTROL | EXECUTE} ON PACKAGE          {ALTER | USAGE} ON SEQUENCE          CONTROL ON INDEX          database_privileges          EXECUTE ON          FROM          levels of system privileges          object_privilege          PASSTHRU ON SERVER          RESTRICT          USE OF TABLESPACE      ROLLBACK statement      SAVEPOINT statement      schema addressing      SELECT statement      SET CONNECTION statement      SET CONSTRAINT statement      SET PATH statement      SET ROLE statement      SET SCHEMA statement      SET SESSION AUTHORIZATION statement      SET statement      SET TIME ZONE statement      SET TRANSACTION statement      sourced user-defined functions      SQL stored procedure      SQL user-defined functions      START TRANSACTION statement      SUBQUERY substatement      TRUNCATE TABLE statement      UNION set operator      UPDATE statement      web site      WHERE clause      window syntax DB2 keywords DBCLOB datatype      DB2      platform comparison DBCLOB function (DB2) DBCREATOR (SQL Server system role) DBPARTITIONNUM function (DB2) DBTIMEZONE function (Oracle) DEC datatype      DB2      platform comparison      SQL Server DEC function (DB2) DECIMAL datatype      DB2      MySQL      Oracle      platform comparison      PostgreSQL 2nd      SQL Server DECIMAL function (DB2) Decimal parameter object type (ADO.NET) declarative processing DECLARE CURSOR command      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax DECODE function      MySQL      Oracle DECOMPOSE function (Oracle) DECRYPT_BIN function (DB2) DECRYPT_CHAR function (DB2) DEGREES function      DB2      MySQL      PostgreSQL      SQL Server DELETE statement      DB2      keywords      MySQL      operators and 2nd      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax delimited identifiers delimiters DENSE_RANK function 2nd 3rd DEPTH function (Oracle) DEREF function      DB2      Oracle deterministic functions dialects, SQL DIAMETER function (PostgreSQL) DIFFERENCE function      DB2      SQL Server DIGITS function (DB2) DISCONNECT statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax DISKADMIN (SQL Server system role) division (/) arithmetic operator DOUBLE datatype      DB2      MySQL      platform comparison DOUBLE function (DB2) Double parameter object type (ADO.NET) DOUBLE PRECISION datatype      DB2      MySQL      Oracle      platform comparison      PostgreSQL      SQL Server double-pound symbol (##) DROP DATABASE statement, quick reference DROP DOMAIN statement, quick reference DROP FUNCTION statement, quick reference DROP INDEX statement, quick reference DROP METHOD statement, quick reference DROP ROLE statement, quick reference DROP statements      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax DROP TABLE statement, quick reference DROP TRIGGER statement, quick reference DROP TYPE statement, quick reference DROP VIEW statement, quick reference DUMP function (Oracle)

Table of Contents