test

What's New in the Sun TCP/IP HL7 Adapter

ProcedureTo Execute the MLLP V2.0 DB Scripts From GUI

  1. Click the Projects tab.

  2. Expand and click CAPS Components Library.

  3. Select and expand Adapters.

  4. Select and expand HL7.

  5. Select and right-click derby_install.sql. from Database Scripts.

  6. Click Open.

    Derby Connection Tree

    This opens the derby_install.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)

  7. Choose the Database Connection from the drop-down list.

  8. Click the Run button.

    Run Database SQL

    The following message is displayed.


    SQL statement(s) executed successfully.
    Execution Successful