ESQL non-reserved keywords

Start of changeThe following keywords are used in the ESQL language but are not reserved. We recommend that you do not use them for variable, function, or procedure names (in any combination of upper and lower case) because, if you do, the code can become difficult to understand.End of change

  • AND
  • ANY
  • AS
  • ATTACH
  • BEGIN
  • BETWEEN
  • BIT
  • BLOB
  • BOOLEAN
  • BY
  • CALL
  • CATALOG
  • CCSID
  • CHAR
  • CHARACTER
  • COMPUTE
  • CONDITION
  • CONSTANT
  • CONTINUE
  • COUNT
  • CREATE
  • CURRENT_DATE
  • CURRENT_GMTDATE
  • CURRENT_GMTTIME
  • CURRENT_GMTTIMESTAMP
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • DATA
  • DATABASE
  • DATE
  • DAY
  • DECIMAL
  • DECLARE
  • DELETE
  • DETACH
  • DO
  • DOMAIN
  • ELSE
  • ELSEIF
  • ENCODING
  • END
  • ESCAPE
  • EVAL
  • EXCEPTION
  • EXISTS
  • EXIT
  • FALSE
  • FIELD
  • FILTER
  • FIRSTCHILD
  • FLOAT
  • FOR
  • FORMAT
  • FOUND
  • FUNCTION
  • GMTTIME
  • GMTTIMESTAMP
  • GROUP
  • HANDLER
  • HAVING
  • HOUR
  • IDENTITY
  • IF
  • IN
  • INOUT
  • INSERT
  • INT
  • INTEGER
  • INTERVAL
  • INTO
  • IS
  • ITERATE
  • LAST
  • LASTCHILD
  • LEAVE
  • LIKE
  • LIST
  • LOCALTIMEZONE
  • LOOP
  • MAX
  • MESSAGE
  • MIN
  • MINUTE
  • MODIFIES
  • MODULE
  • MONTH
  • MOVE
  • NAME
  • NAMESPACE
  • NEXTSIBLING
  • NULL
  • OF
  • OPTIONS
  • OR
  • ORDER
  • OUT
  • PARSE
  • PASSTHRU
  • PATH
  • PLACING
  • PREVIOUSSIBLING
  • PROCEDURE
  • PROPAGATE
  • READS
  • REFERENCE
  • REPEAT
  • RETURN
  • RETURNS
  • ROW
  • SAMEFIELD
  • SCHEMA
  • SECOND
  • SELECT
  • SET
  • SEVERITY
  • SOME
  • SQL
  • SQLCODE
  • SQLERRORTEXT
  • SQLEXCEPTION
  • SQLNATIVEERROR
  • SQLSTATE
  • SQLWARNING
  • SUM
  • THE
  • THEN
  • THROW
  • TIME
  • TIMESTAMP
  • TO
  • TRUE
  • TYPE
  • UNKNOWN
  • UNTIL
  • UPDATE
  • USER
  • UUIDASBLOB
  • UUIDASCHAR
  • VALUE
  • VALUES
  • WHERE
  • WHILE
  • YEAR
Related concepts
ESQL overview
Related tasks
Developing ESQL
Related reference
ESQL reserved keywords