How to fetch records from db2 table

HCL Domino Domino Forum
1

I m trying to fetch records from db2 table.Please let me know how to fetch records and how to store the result records.

2

Subject: you can look at ls:do for a simple example.

Each one of the following ways are separate ways to get at relational data:

  • You can use ls:do for a simple example.

  • Also, for storing connection information, username, and password as part of the database (as oppose in odbc), look into LEI.

  • If you let Lotus Notes handle it, just create a database with DECS and set it up, run the “populate” script, and each time a document is edited in Lotus Notes, the server will make the necessary SQL calls for you.

-Kyle Huang