Generating database schema from SQL statements

When you configure a complex inbound action SQL statement to compose a message, the imported table schema must match.

A specified schema is the schema that is generated from a SQL statement and has a customized name. This is generated from the SQL statement for the individual database thread.

Note: When generating SQL statement schema in the Database Schema Configurator, the SQLite Database Data Type column does not show any data. This does not happen with Oracle and SQLServer. This only happens with SQLite and does not effect any other operation that is related to SQLite SQL statement schema.

In database protocol thread configuration, you can compose a message with specific columns. To do this, define a SQL Statement Schema to only include those specific columns and apply it to the database protocol thread.

For example, a table named Table1 is in the database, and contains column1, column2, and column3.

To use only column1 and column3 to compose the database inbound message:

  1. Click Add SQL Statement Schema to open the SQL Statement Schema Configurator dialog box.
  2. Specify a name for the SQL statement schema in Name.
  3. For SQL Statement, specify select column1, column3 from table1 and click OK. The schema files are generated according to the SQL statement.
  4. In Network Configurator, open the Database Inbound Protocol Properties dialog box and select the new SQL Statement schema from Table Schema. Other configuration steps are the same as that of table schema.