LEI - MINUS/EXCEPT statement ability between Notes and SQL


As in SQL, one would use MINUS or EXCEPT to return a set of results containing only differences. I would like to know how to mimic this functionality between a Notes DB and a SQL Table using LEI.

Has anyone ever exported only "changed documents" using LEI?

The reason for my question is that the exports which we currently have are full exports and are beginning to time out. These are inefficient and would appreciate advice on what surely must be common practice.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I'm not a Notes user at all, but ... can you change the table structure of your notes db table? If so, can you add an "ExportedOn" field, filling it when you do the export and only exporting those notes not already exported?

If you can't change the table itself you can maybe add a table with the same uniqueness key (record number or whatever) and the ExportedOn field.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.