Writing formulas and scripts to access relational databases

The following @functions access an external database through ODBC and return a value or list of values:

  • @DbColumn returns all the values in one column of a table, or all the distinct values.
  • @DbLookup returns selected values in one column of a table by matching keys.
  • @DbCommand passes a command to an external DBMS and returns the result.

@DbColumn and @DbLookup can only retrieve data. They can't add, delete, or modify data, or perform other operations. @DbCommand can retrieve data or send other SQL statements that can change data. LotusScript® provides a wider range of capabilities including the ability to update the external database.

The LotusScript Data Object (LS:DO)

This LSX-compliant module allows you to use LotusScript to write applications that incorporate data from external non-Notes data sources. Your script may perform the following steps:

  • Establish a connection with the data source.

    Each connection requires the data source name. If the data source name is not already registered, you must also provide additional information.

  • Use SQL statements to send queries or other actions to the data source.
  • Retrieve and use result sets.
  • Read, modify, or add information into relational databases.
  • Disconnect from the data source.

For more information on writing scripts to access external databases, see the topic "Accessing external databases through LS:DO" on the Notes® Domino® Application development wiki at http://www-10.lotus.com/ldd/ddwiki.nsf.