: 4399 | 106118 | 11884

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

: 8
: 8
: 0
: Lotus Enterprise Integrator
: DB2, LEI
: Bruce Lill6677 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 Pereira1697 (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 Lill6677 (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 >>


3
Add server and database as optional parameters for @GetProfileField and @SetProfileField
8
Have an option to copy an URL from an e-mail (or other)
-1
System wide Web Query Save
0
Design Element PostSave event
56
Please update Domino to fully support TLS (SSL v3.1)
4
Integrated ICS OneUI Editor for Designer
6
Agent context menu in editor tab eg. "Run Agent"
55
When deleting user, delete archive & roaming files as well as mail file
12
Set properties for all selected Forms







IdeaJam developed by