Problem solve Get help with specific problems with your technologies, process and projects.

Export rich text field data from Notes to Informix

I need to export data from a Notes database to an Informix database. I can successfully export text, date or number data to the Informix tables. But when I try to export rich text field data (retrieved in LotusScript with the GetFormattedText method) from the Notes database to the Informix table's column, which is a CLOB data type, it fails.

This is the first time I've worked with Informix. I'm doing this export with LotusScript and an ODBC connection on my desktop. What should I do?

Also, I have a SQL Server database running on my local Notes server, where this application resides. I created a test table to which I can write this data, and when I try to write the rich text field data to a "text" data type in the SQL server table of my test database, it only writes some of the data, and only on some of the rich text field data. I'm using a string var to do this. Does this suggest a memory limitation for the string var I'm using in LotusScript?

Getting rich text data from Notes to another database system is a challenge, since Lotus uses its own proprietary format for rich rext fields. Try using LEI, which "understands" rich text fields. However, even with this method, your front-end Informix application still may not present the RT data properly.

Do you have comments on this Ask the Expert question and response? Let us know.

Dig Deeper on LEI and DECS for Lotus Notes Domino

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...