HCL Domino - Accessing external databases through LS:DO using @functions - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

FORMULA LANGUAGE

Accessing external databases through LS:DO using @functions
Example

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 first four parameters are the same for all three @functions and establish access to the database through ODBC. The parameters are:

"ODBC" as a string constant; or "ODBC" : "NoCache"
Name of the data source as defined in the table of data sources (odbc.ini in Windows)
User ID, list of two user IDs, or a null string, depending on the external data source
Password, list of two passwords, or a null string, depending on the external data source
(@DbColumn and @DbLookup) Name of the table to be accessed
(@DbCommand) Command string to be executed
(@DbColumn and @DbLookup) Name of the column to be accessed
Option for handling null data returned by the data source
(@DbLookup) Name of the column containing the key
(@DbLookup) Value of the key as the appropriate data type, or a list
(@DbColumn and @DbLookup) List of two elements: "Distinct" as a string argument or null string; "Ascending" or "Descending" as a string argument

Where user IDs and passwords are required, you can specify null strings and let the user supply them when the @function executes.

Example
See Also

Formula Language Coding Guidelines

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Feedback on Help or Usability?

Help on Help

All Help Contents