•  Preface
  • Purpose
  • Audience
  • Organization
  • Typographical conventions
  • Examples of syntax diagrams (SQL)
•  OpenEdge SQL Statements
  • ALTER DATABASE SET PRO_ENABLE_LARGE_KEYS 'Y'
  • ALTER DATABASE SET PRO_ENABLE_64BIT_SEQUENCES 'Y'
  •  ALTER GROUP
    • Authorization
    • Related Statement
  •  ALTER SEQUENCE
    • Authorization
    • Related Statement
  •  ALTER TABLE
    •  Migrating data from existing unpartitioned tables to partitioned tables
      • Enabling a table for partitioning
      • Marking partitions as split targets
      • Moving the physical data from the composite initial partition to its respective partitions
    •  ALTER TABLE syntax to add or drop partitions
      • Authorization
      • Related statements
  •  ALTER TENANT
    • Authorization
    • Related Statement
  •  ALTER USER
    • Authorization
    • Related statements
  • AUDIT INSERT
  •  AUDIT SET
    • Authorization
  •  CALL
    • Authorization
    • Related statements
  • Column constraints
  •  COMMIT
    • Related Statement
  •  CONNECT AS CATALOG
    • Authorization
    • SQL Compliance
    • Related statements
  •  CREATE DOMAIN
    • Authorization
    • Related Statement
  •  CREATE GROUP
    • Authorization
    • Related Statement
  •  CREATE INDEX
    •  Creating indexes for partitioned tables
      • Authorization
      • Related statements
  •  CREATE PROCEDURE
    • Authorization
    • Related statements
  •  CREATE SEQUENCE
    • Authorization
    • Related Statements
  •  CREATE SUPER-TENANT
    • Authorization
    • Related Statement
  •  CREATE SYNONYM
    • Authorization
    • Related Statement
  •  CREATE TABLE
    • Authorization
    • Related Statement
  •  CREATE TENANT
    • Authorization
    • Related Statement
  •  CREATE TRIGGER
    • Authorization
    • Related statements
  •  CREATE USER
    • Authorization
    • Related statements
  •  CREATE VIEW
    • Authorization
    • Related statements
  •  DELETE
    • Authorization
    • Related statements
  •  DISCONNECT CATALOG
    • Authorization
    • SQL Compliance
    • Related statements
  •  DROP DOMAIN
    • Authorization
    • Related Statement
  •  DROP GROUP
    • Authorization
    • Related statements
  •  DROP INDEX
    • Authorization
    • Related statements
  •  DROP PROCEDURE
    • Authorization
    • Related statement
  •  DROP SEQUENCE
    • Authorization
    • Related Statement
  •  DROP SYNONYM
    • Authorization
    • Related statement
  •  DROP TABLE
    • Authorization
    • Related statement
  •  DROP TENANT
    • Authorization
    • Related Statement
  •  DROP TRIGGER
    • Authorization
    • Related statement
  •  DROP USER
    • Authorization
    • Related statements
  •  DROP VIEW
    • Authorization
    • Related statement
  •  GRANT
    • Authorization
    • Related statement
  •  INSERT
    • Authorization
    • Related statements
  •  LOCK TABLE
    • Authorization
    • Related statements
  •  REVOKE
    • Authorization
    • Related statement
  •  ROLLBACK
    • Authorization
    • Related statements
  •  SELECT
    •  Authorization
      • Authorization
      • Related Statements
    • COLUMN_LIST clause
    • TOP clause
    • FROM clause
    • WHERE clause
    •  GROUP BY clause
      • Grouping by column
      • Grouping by alias
      • Grouping by expression
    • HAVING clause
    • ORDER BY clause
    • OFFSET and FETCH clauses
    • WITH clause
    • FOR UPDATE clause
  •  SET CATALOG
    • Authorization
    • SQL Compliance
    • Related statements
  • SET PRO_CONNECT LOG
  • SET PRO_CONNECT QUERY_TIMEOUT
  • SET PRO_SERVER QUERY_TIMEOUT
  • SET PRO_SERVER LOG
  •  SET ROWCOUNT
    • Related Statement
  •  SET SCHEMA
    • Authorization
  •  SET TRANSACTION ISOLATION LEVEL
    • Authorization
    • Related statements
  •  SHOW CATALOGS
    • Authorization
    • SQL Compliance
    • Related statements
  •  SHOW GROUP
    • Authorization
    • Related Statement
  •  SHOW PARTITION
    • Authorization
  •  SHOW ROWCOUNT
    • Related Statement
  •  SHOW TENANT
    • Authorization
    • Related Statement
  •  SHOW ENCRYPT ON
    • Authorization
    • SQL Compliance
    • Related statements
  • Table constraints
  •  UPDATE
    • Authorization
    • Related statements
  •  UPDATE STATISTICS
    • Authorization
•  OpenEdge SQL Functions
  •  About OpenEdge SQL functions
    • Aggregate functions
    • Scalar functions
  •  ABS
    • Compatibility
  •  ACOS
    • Compatibility
  •  ADD_MONTHS
    • Compatibility
  •  ASCII
    • Compatibility
  •  ASIN
    • Compatibility
  •  ATAN
    • Compatibility
  •  ATAN2
    • Compatibility
  • AVG
  •  CASE
    • Compatibility
  •  CAST
    • Compatibility
  •  CEILING
    • Compatibility
  •  CHAR
    • Compatibility
  •  CHR
    • Compatibility
  •  COALESCE
    • Compatibility
  •  CONCAT
    • Compatibility
  •  CONVERT (ODBC compatible)
    • Compatibility
  •  CONVERT (Progress extension)
    • Compatibility
  •  COS
    • Compatibility
  • COUNT
  •  CURDATE
    • Compatibility
  •  CURTIME
    • Compatibility
  • CURRVAL
  •  DATABASE
    • Compatibility
  •  DAYNAME
    • Compatibility
  •  DAYOFMONTH
    • Compatibility
  •  DAYOFWEEK
    • Compatibility
  •  DAYOFYEAR
    • Compatibility
  •  DB_NAME
    • Compatibility
  •  DECODE
    • Compatibility
  •  DEGREES
    • Compatibility
  •  EXP
    • Compatibility
  •  FLOOR
    • Compatibility
  •  GREATEST
    • Compatibility
  •  HOUR
    • Compatibility
  •  IFNULL
    • Compatibility
  •  INITCAP
    • Compatibility
  •  INSERT
    • Compatibility
  •  INSTR
    • Compatibility
  •  LAST_DAY
    • Compatibility
  •  LCASE
    • Compatibility
  •  LEAST
    • Compatibility
  •  LEFT
    • Compatibility
  •  LENGTH
    • Compatibility
  •  LOCATE
    • Compatibility
  •  LOG10
    • Compatibility
  •  LOWER
    • Compatibility
  •  LPAD
    • Compatibility
  •  LTRIM
    • Compatibility
  • MAX
  • MIN
  •  MINUTE
    • Compatibility
  •  MOD
    • Compatibility
  •  MONTH
    • Compatibility
  •  MONTHNAME
    • Compatibility
  •  MONTHS_BETWEEN
    • Compatibility
  •  NEXT_DAY
    • Compatibility
  • NEXTVAL
  •  NOW
    • Compatibility
  •  NULLIF
    • Compatibility
  •  NVL
    • Compatibility
  •  PI
    • Compatibility
  • POWER
  •  PREFIX
    • Compatibility
  • PRO_ARR_DESCAPE function
  • PRO_ARR_ESCAPE function
  • PRO_ELEMENT function
  •  QUARTER
    • Compatibility
  •  RADIANS
    • Compatibility
  •  RAND
    • Compatibility
  •  REPEAT
    • Compatibility
  •  REPLACE
    • Compatibility
  •  RIGHT
    • Compatibility
  •  ROUND
    • Compatibility
  •  ROWID
    • Compatibility
  •  RPAD
    • Compatibility
  •  RTRIM
    • Compatibility
  •  SECOND
    • Compatibility
  •  SIGN
    • Compatibility
  •  SIN
    • Compatibility
  •  SQRT
    • Compatibility
  •  SUBSTR
    • Compatibility
  •  SUBSTRING (ODBC compatible)
    • Compatibility
  •  SUFFIX
    • Compatibility
  • SUM
  •  SYSDATE
    • Compatibility
  •  SYSTIME
    • Compatibility
  •  SYSTIMESTAMP
    • Compatibility
  •  TAN
    • Compatibility
  •  TO_CHAR
    • Compatibility
  •  TO_DATE
    • Compatibility
  •  TO_NUMBER
    • Compatibility
  •  TO_TIME
    • Compatibility
  •  TO_TIMESTAMP
    • Compatibility
  •  TRANSLATE
    • Compatibility
  •  UCASE
    • Compatibility
  •  UPPER
    • Compatibility
  •  USER
    • Compatibility
  •  WEEK
    • Compatibility
  •  YEAR
    • Compatibility
•  OpenEdge SQL Reserved Words
  • OpenEdge SQL reserved words
•  OpenEdge SQL Error Messages
  • Overview
  • Error codes, SQLSTATE values, and messages
•  OpenEdge SQL System Limits
  • OpenEdge SQL system limits
•  OpenEdge SQL System Catalog Tables
  • Overview of system catalog tables
  • SYSTABLES
  • SYSCOLUMNS
  • SYSINDEXES
  • SYSCALCTABLE
  • SYSNCHARSTAT
  • SYSCOLAUTH
  • SYSCOLSTAT
  • SYSCOLUMNS_FULL
  • SYSDATATYPES
  • SYSDATESTAT
  • SYSDBAUTH
  • SYSFLOATSTAT
  • SYSIDXSTAT
  • SYSINTSTAT
  • SYSNUMSTAT
  • SYSPROCBIN
  • SYSPROCCOLUMNS
  • SYSPROCEDURES
  • SYSPROCTEXT
  • SYSREALSTAT
  • SYSSEQAUTH
  • SYSSEQUENCES
  • SYSSYNONYMS
  • SYSTABAUTH
  • SYSTABLES_FULL
  • SYSTBLSTAT
  • SYSTIMESTAT
  • SYSTINYINTSTAT
  • SYSTRIGCOLS
  • SYSTRIGGER
  • SYSTSSTAT
  • SYSTSTZSTAT
  • SYSNVARCHARSTAT
  • SYSVIEWS
  • SYS_CHKCOL_USAGE
  • SYS_CHK_CONSTRS
  • SYS_KEYCOL_USAGE
  • SYS_REF_CONSTRS
  • SYS_TBL_CONSTRS
•  Data Type Compatibility
  • Supported ABL data types and corresponding OpenEdge SQL data types
•  OpenEdge SQL Language Elements
  •  OpenEdge SQL identifiers
    • Conventional identifiers
    • Delimited identifiers
  • Number formats
  • Date-time formats
  • Date formats
  • Time formats
  •  Data types
    •  Character data types
      • Maximum length for VARCHAR
      • National Language Support (NLS)
      • Concatenation operator
    • Exact numeric data types
    • Approximate numeric data types
    • Date-time data types
    •  Bit string data types
      • Maximum length for VARBINARY
      • LVARBINARY limitations
      • Language support for LVARBINARY
      • Utility support for LVARBINARY
      • Utility support for LVARCHAR (CLOBS)
    •  Array data types
      • ARRAY element reference
      • Default value for ARRAY columns
      • Assignment
      • Comparison
  •  Literals
    • Numeric literals
    • Character-string literals
    •  Date-time literals
      • Date literals
      • Time literals
      • Timestamp literals
  •  Relational operators
    • Basic Predicate
    •  Quantified Predicate
      • BETWEEN Predicate
      • NULL Predicate
      • LIKE Predicate
      • EXISTS Predicate
      • IN Predicate
      • OUTER JOIN Predicate
    • Numeric arithmetic expressions
    • Date arithmetic expressions
•  OpenEdge SQL Elements and Statements in Backus Naur Form
  •  Data types syntax in BNF
    •  Data Type
      • Character data type
      • Exact numeric data type
      • Approximate numeric data type
      • Date-time data type
      • Bit string data type
  •  Expressions syntax in BNF
    •  Expression (expr)
      • Numeric arithmetic expression
      • Date arithmetic expression
    •  Conditional expression
      • Case expression
      • Searched case expression
      • Simple case expression
  •  Literals syntax in BNF
    • Date literal
    • Time literal
    • Timestamp literal
    • Timestamp with time zone literal
  •  Query Expressions syntax in BNF
    •  Query expression
      • Set operator
      • Query specification
      • Table reference
      • Joined table
      • From clause inner join
      • Where clause inner join
      • From clause outer join
      • Where clause outer join
  •  Search conditions syntax in BNF
    •  Search condition
      • Predicate
      • Relational operator
      • Basic predicate
      • Quantified predicate
      • Between predicate
      • Null predicate
      • Like predicate
      • Exists predicate
      • In predicate
      • Outer join predicate
  •  Statements, DDL and DML syntax in BNF
    • ALTER USER
    • CALL
    • COMMIT
    • CREATE INDEX
    •  CREATE PROCEDURE
      • Parameter Declaration
    • CREATE SYNONYM
    •  CREATE TABLE
      • Column Definition
      • Column Constraint
      • Table Constraint
    • CREATE TRIGGER
    • CREATE USER
    • CREATE VIEW
    • DELETE
    • DROP INDEX
    • DROP PROCEDURE
    • DROP SYNONYM
    • DROP TABLE
    • DROP TRIGGER
    • DROP USER
    • DROP VIEW
    • GRANT RESOURCE, DBA
    •  GRANT PRIVILEGE
      • PRIVILEGE Syntax
    • INSERT
    • LOCK TABLE
    • REVOKE RESOURCE, DBA
    •  REVOKE PRIVILEGE
      • PRIVILEGE Syntax
    • ROLLBACK
    • SELECT
    • SET SCHEMA
    •  UPDATE
      • Assignment clause
    • UPDATE STATISTICS
•  Compliance with Industry Standards
  • Scalar functions
  • SQL-92 DDL and DML statements
•  Syntax for ABL Attributes
  • OpenEdge SQL keywords for ABL table attributes
•  Java Class Reference
  •  Java classes and methods
    • setParam
    • makeNULL
    • execute
    • rowCount
    • open
    • close
    • fetch
    • found
    • wasNULL
    • getValue
    • set
    • insert
    • getDiagnostics
    • log
    • err
  •  DhSQLException
    •  Constructors
      • Constructors
      • Parameters
    •  DhSQLException.getDiagnostics
      • Format
      • Returns
      • Parameters
      • Throws
  •  DhSQLResultSet
    •  Constructors
      • Constructors
      • Parameters
      • Throws
    •  DhSQLResultSet.insert
      • Format
      • Returns
      • Parameters
      • Throws
    •  DhSQLResultSet.makeNULL
      • Format
      • Returns
      • Parameters
      • Throws
    •  DhSQLResultSet.set
      • Format
      • Returns
      • Parameters
      • Throws
  •  SQLCursor
    •  Constructors
      • Constructors
      • Parameters
      • Throws
    •  SQLCursor.close
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.fetch
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.found
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.getParam
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.getValue
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.makeNULL
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.open
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.registerOutParam
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.rowCount
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.setParam
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLCursor.wasNULL
      • Format
      • Returns
      • Parameters
      • Throws
  •  SQLIStatement
    •  Constructors
      • Constructors
      • Parameters
      • Throws
    •  SQLIStatement.execute
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLIStatement.makeNULL
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLIStatement.rowCount
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLIStatement.setParam
      • Format
      • Returns
      • Parameters
      • Throws
  •  SQLPStatement
    •  Constructors
      • Constructors
      • Parameters
      • Throws
    •  SQLPStatement.execute
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLPStatement.makeNULL
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLPStatement.rowCount
      • Format
      • Returns
      • Parameters
      • Throws
    •  SQLPStatement.setParam
      • Format
      • Returns
      • Parameters
      • Throws
•  JDBC Conformance Notes
  • Supported data types
  • Return values for DatabaseMetaData
• OpenEdge SQL and ODBC Data Types
• SQLGetInfo
•  ODBC Scalar Functions
  •  Scalar functions
    • String functions
    • Numeric functions
    • Date and time functions
  • System functions
•  Embedded SQL
  •  ESQL elements and statements
    •  BEGIN-END DECLARE SECTION
      • Authorization
      • Related statements
    •  CLOSE
      • Authorization
      • Related statements
    •  CONNECT
      • Authorization
      • Related statements
    •  DECLARE CURSOR
      • Authorization
      • Related statements
    • DESCRIBE
    •  DESCRIBE BIND VARIABLES
      • Authorization
      • Related statements
    •  DESCRIBE SELECT LIST
      • Authorization
      • Related statements
    •  DISCONNECT
      • Authorization
      • Related statements
    •  EXEC SQL delimiter
      • Authorization
    •  EXECUTE
      • Related statements
    •  EXECUTE IMMEDIATE
      • Related statement
    •  FETCH
      • Authorization
      • Related statements
    •  GET DIAGNOSTICS
      • Related statements
    •  GET DIAGNOSTICS EXCEPTION
      • Related statements
    •  OPEN
      • Authorization
      • Related statements
    •  PREPARE
      • Authorization
      • Related statements
    •  SET CONNECTION
      • Authorization
      • Related statements
    •  WHENEVER
      • Authorization
      • Related statements
  •  ESQL elements and statements in Backus Naur Form (BNF)
    • BEGIN‑END DECLARE SECTION
    • Host Language Type
    • CLOSE
    • CONNECT
    • CONNECT STRING
    • DECLARE CURSOR
    • DESCRIBE BIND VARIABLES
    • DESCRIBE SELECT LIST
    • DISCONNECT
    • EXEC SQL
    • EXECUTE
    • EXECUTE IMMEDIATE
    • FETCH
    • GET DIAGNOSTICS
    • Header Info Item
    • GET DIAGNOSTICS EXCEPTION
    • Detail Info Item
    • OPEN
    • PREPARE
    • SET CONNECTION
    • SET TRANSACTION ISOLATION LEVEL
    • ISOLATION LEVEL NAME
    • WHENEVER
  • Compliance with industry standards