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)
