New SQL Database Activities
This version of LANSA Composer introduces a new suite of twelve activities for performing SQL operations on a database identified by a LANSA Composer database configuration. The databases can be on any network addressable server. So, for example, LANSA Composer on an IBM i server could address an MS SQL Server database on a Windows server, or vice-versa..
Typically in LANSA Composer, most database activity is accomplished through the use of Transformation Maps. However, these new activities provide another option for performing limited database query and update operations on an SQL database. In addition, they provide a means of invoking SQL stored procedures in the target database.
The SQL database activities are not intended for high-throughput, high-volume database operations. Rather they provide a simple means to complete a business process integration solution that may not otherwise have been possible, with some simple, low-volume database access and/or maintenance.
The new SQL database activities comprise:
- Activities to establish or disconnect an SQL database connection:
|
- Activities to query the database:
|
- Activities to perfom insert, update and delete operations in the database:
|
- Activities to execute an SQL stored procedure in the database:
|
- Activities to implement transaction control relating to any database insert, update or delete operations you have performed:
|
- Activities to set parameter values for an SQL operation:
|