QUESTION POSED ON: 13 April 2004
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?
|
