CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE TESTTABLE(ID INTEGER NOT NULL PRIMARY KEY,VALUE VARCHAR,TEXT LONGVARCHAR)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO TESTTABLE VALUES(1,'some value','this is the longvarchar field')