1 Reply Latest reply on Nov 27, 2001 3:01 PM by Peter Fagerlund

    Hypersonic and "Having" sql clause

    Kai Newbie

      I use a freeware db vis tool to disply the contents of a test database. If I include a "Having" in an sql statement running Hypersonic I get always an error back. If I use the same statement with sapdb it works perfectly.
      Anybody a clue why??? Is the "Having" statement not implemented for Hypersonic???

        • 1. Re: Hypersonic and
          Peter Fagerlund Newbie

          Hypersonic SQL currently supports the following SQL statements and syntax:

          Alphabetical list:

          CALL
          CHECKPOINT
          COMMIT
          CONNECT
          CREATE ALIAS
          CREATE INDEX
          CREATE TABLE
          CREATE USER
          DELETE
          DISCONNECT
          DROP INDEX
          DROP TABLE
          DROP USER
          GRANT
          INSERT
          REVOKE
          ROLLBACK
          SCRIPT
          SELECT
          SET AUTOCOMMIT
          SET IGNORECASE
          SET LOGSIZE
          SET PASSWORD
          SET REFERENTIAL_INTEGRITY
          SET WRITE_DELAY
          SHUTDOWN
          UPDATE