Sun Microsystems Sun Adapter IP HL 7 - Manual (Page 143)

This opens the SQL Editor window along with the SQL Statement.
CREATE TABLE HL7MESSAGELOG (MESSAGEID VARCHAR(250), APPLICATIONID VARCHAR(250) ,
REQUESTMESSAGE CLOB, RESPONSEMESSAGE CLOB, STATUS SMALLINT, CREATEDTIME TIMESTAMP,
LASTUPDATEDTIME TIMESTAMP)
In the SQL Editor toolbar, click in the Connection field and select the database connection from
the drop-down list.
In the toolbar, click Run SQL.
A message appears in the Output panel indicating whether the script was run successfully.
5
6
MLLP V2 and the Sample Projects
Sun Adapter for TCP/IP HL7 User's Guide 143