Q

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.

This was first published in June 2004

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • 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 ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close