Add an SQL activity to allow for an sql statement to be entered 
Use this IdeaSpace to post ideas about Lotus Enterprise Integrator.

: 9
: 9
: 0
: Lotus Enterprise Integrator
: DB2, LEI
: Bruce Lill10666 19 Feb 2009
: / Email
Notrix allows for this and it would let you do things like a join to pull all data instead of having to run multiple activities to get the data.
You could test the sql out in IBM DB2 developer or other product and then just paste that statement in.
The results of the sql would be available to be mapped to the Notes or other RDBMS field names.

1) Vitor Pereira4271 (19 Feb 2009)
I'm voting yes because I assume you're asking for this to be possible in a replication activity, right? You can already use it in a direct transfer.
2) Bruce Lill10666 (19 Feb 2009)
Yes, I forgot that part. For repliction.


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

IdeaJam developed by

Elguji Software Logo