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:
- Click SQL Statement Schema Configurator dialog box. to open the
- Specify a name for the SQL statement schema in Name.
-
For SQL Statement, specify
select column1, column3 from table1
and click . The schema files are generated according to the SQL statement. - 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.