Once again,how can I use a DB2 procedure to retrieve a data to Lotus Notes via DCR? I need to compose document in Lotus Notes database, that is connected to DB2, write an ID to a first field, press the F9 refresh and retrieve a value from DB2 procedure parameter to the second field. It’s a bit more difficult, thats why I can’t use a table or view to retrieve those data. I really need to get data via procedure parameter.
My first post is here:
https://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/087010817d787a44852571070057a5e0?OpenDocument
Has anyone any idea, pleas. Jiri
Subject: DCR
Don’t use DCRs, use the DECS Administration database to configure this - there is a section where you can specify the stored procedure and parameters in and out. If you search the Lotus Knowledge base there is a great document that gives a full example of how to configure DECS to work with DB2 stored procedures. I used that the first time I tried it and it worked a treat!