DB2 Access Server

HCL Domino Domino Forum
1

Hi

I’ve got DB2 Access Server (finally!) working, and can create a DAV. However, I can only do a 1:1 mapping from form fields to columns in the table?

I was hoping to populate a DB2 table from a Notes view, or from a temp field in the form with a formula, so that the data would arrive in the table cleansed. Is this not possible?

Also, is there a way to schedule DB2 Access Server to update the table? We don’t want to click the populate button in the Designer client every time.

Your comments would be appreciated.

2

Subject: Access table data and updating

The DAV updates are performed in the same transaction as the NSF ones (that is, as part of NSFNoteUpdate). That way they are atomic and the data remains in sync between the DB2 tables housing the NSF data and those housing DAVs. So, supplying data for DAVS from views would break that design.