CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE OBSERVATION_FACT(ENCOUNTER_NUM INTEGER,PATIENT_NUM INTEGER,CONCEPT_CD VARCHAR(50),PROVIDER_ID VARCHAR(50),START_DATE TIMESTAMP,MODIFIER_CD VARCHAR(50),VALTYPE_CD VARCHAR(50),TVAL_CHAR VARCHAR(2000),NVAL_NUM DECIMAL(20),VALUEFLAG_CD VARCHAR(50),QUANTITY_NUM DECIMAL(20),UNITS_CD VARCHAR(50),END_DATE TIMESTAMP,LOCATION_CD VARCHAR(50),CONFIDENCE_NUM DECIMAL(20),OBSERVATION_BLOB VARCHAR(10000),UPDATE_DATE TIMESTAMP,DOWNLOAD_DATE TIMESTAMP,IMPORT_DATE TIMESTAMP,SOURCESYSTEM_CD VARCHAR(50),UPLOAD_ID INTEGER,INSTANCE_NUM INTEGER)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 0 MILLIS
SET SCHEMA PUBLIC
INSERT INTO OBSERVATION_FACT VALUES(1,1,'@','1','2012-04-19 00:00:00.000000000','@','T','T',NULL,'T',0,NULL,'2012-04-19 00:00:00.000000000',NULL,NULL,'patient took 50mg of aspirin for pain in knee.','2012-04-19 00:00:00.000000000','2012-04-19 00:00:00.000000000','2012-04-19 00:00:00.000000000','TEST',0,0)