This could help expand the adoption of LC LSX, DECS and LEI if they supported more open source RDBMS.
I would like to see a new LEI Activity that would allow the entire contents of one (Notes) database placed into an another (Notes) database. This would allow me to test application better. I could take a copy of production data or reload specific test data to rerun test scripts ...
It would be great if you could drag a (Oracle / DB2) table name (say from PL/SQL Developer) and drop it over an LEI object instance (LEI Administrator DB, LEI connection doc,.... ) and have it autoload the "Owner", "Name" and "Fields" on the connection doc. Prompt for the user ...
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....
LEI should support @ThisValue while using Enforce Form Design functionality in notes connection documents. Currently LEI will not evaluate field formula if contains @thisValue.
DB2 access, ecpecially in the context of mainframes, often requires (due to monitoring issues, security issues, etc) static sql when accessing the database (SQLJ from java). It would be nice if LEI would support binding and customization of sql queries.
Some times due to the replication conflicts or some other reasons we will end up with duplicate docs having same primary key. Currently replication job stops processing the rest of docs when it encounter duplicate primary key documents.
What we need LEI should skip the error doc and keep running on rest of docs thats way we no ...
There should be a way the comparison of field values could be performed after translation formulas had run on the source data, so that document would not be modified every single time when replication job runs.
Any user using Notes, Sametime, Connections, Office, OpenOffice, Symphony, TAP, Firefox and plenty of other tools (IBM or not) are offered a spell check function where unknown words can be added. Great! So, when I come with a new word or acronym, I have to add it between 5 and 10 ...
When printing in Lotusscript, the information is 'printed' to the log when running scheduled agents. I would love that this printing goes to the LEI log of the activity when the script is run from a LEI activity.
I'm trying to call a stored procedure on my DB2 database. I wrote the procedure and I think it works (it compiles!!!). Anyway, when I try to call it from a lotusscript agent I can't get it to work. All that is returned is: "1544 Cannot find connector 'db2'". Anybody ...