Home
HCL Domino Designer Basic User Guide and Reference
Basic product usage information and programming language reference information.
Connectors
Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
LSX for Connectors
LotusScript® Extensions for Connectors (LC LSX) enhances the power of Notes® by extending its scripting to data outside of Notes through the use of Connectors. The programming model is independent of the individual connector. This eliminates the need to learn each individual system, while at the same time allowing experienced users to access the individual features of a specific system.
Appendix C Connector Properties
This chapter provides information about connector properties. These properties are used when creating connections using the Lotus® Connector LotusScript® Extensions.
Notes® Connector Properties
The following table defines the properties for the Connector for Notes®.
Processing Attachments Stored in Rich Text Fields
Notes® is primarily a document management system -- not a relational database management system (RDBMS). Because of this, Notes performs special handling for attachments stored in rich text fields. It stores the attachment data separately from the rich text field data. Currently you can only transfer attachments from Notes to Notes; rich text fields with attachments do not store correctly in the target RDBMS's such as DB2® and Oracle.

Processing Attachments Stored in Rich Text Fields

Notes® is primarily a document management system -- not a relational database management system (RDBMS). Because of this, Notes® performs special handling for attachments stored in rich text fields. It stores the attachment data separately from the rich text field data. Currently you can only transfer attachments from Notes® to Notes®; rich text fields with attachments do not store correctly in the target RDBMS's such as DB2® and Oracle.

You can use the Extract File Attachments option to save attachments to files on disk. You can then use LotusScript® to read the files, store their contents in LCFields, and save the LCFields to binary fields in a RDBMS. This level of scripting requires LotusScript® expertise.