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.
This was first published in June 2004