Re: Notes front-end to 400 file -- DOMINO400

Excellent suggestion.  Remember that the agent should RunOnServer.




dmounier@homsys.com on 05/12/2000 03:11:14 AM
Please respond to DOMINO400@midrange.com@Internet
To:     DOMINO400@midrange.com@Internet
cc:      
Fax to: 
Subject:        Re: Notes front-end to 400 file

Scott,

You can do data exchange between Domino and DB2/400 by using lotus script
extensions.

If your Domino is on the AS/400, you can use the direct interface (CLI) to
access data in DB2.
If you Domino is on an other box (NT box for example) you can use the Client
Access ODBC driver to access DB2.
In the two cases, it is prety simple to create a front-end interface in Notes
based on the DB2 data.
Have a look in the designer client help by typing "odbc" in the search form to
displays examples.
You can write your Lotus import/export scripts in agents and execute them via a
lotus interface.

Damien.

Scott Johnson wrote:

> I need to create an interface in Notes that does maintenance
> to a file in DB2/400.  I think DECS is my answer, but am unclear
> on a couple of things.
>
> I can create a form that uses DECS to 'connect' to the file on
> the back-end.  My big question:  is there a way to create a Notes
> app that is just a front-end to a back-end DB where documents
> won't be created in the Notes app?  If so, any samples to share?
>
> Did any of that make sense? Hopefully it did.  I am a newbie
> and am learning my way around development in Notes/Domino.
> I have looked at the entreprise integration redbook and a lot
> of other manuals and cannot find a clear answer to my question.
>
> --  THANKS
> ------------------------------------------------------
> Scott P. Johnson
> Microcomputer Development Specialist
> IBM Certified Specialist - AS/400 RPG Programmer
> Highsmith Inc.
> W5527 Hwy 106, PO BOX 800
> Fort Atkinson, WI 53538-0800
> TEL:  920-563-9571                FAX:  920-563-7395
> sjohnson@highsmith.com
> www.highsmith.com
> ------------------------------------------------------
> +---
> | This is the Domino/400 Mailing List!
> | To submit a new message, send your mail to DOMINO400@midrange.com.
> | To subscribe to this list send email to DOMINO400-SUB@midrange.com.
> | To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: meechamw@ptd.nett
> +---

--
Damien Mounier
------------------------------------------------
HOMMES & SYSTEMES
Boulogne - Toulouse - Bordeaux - Marseille - Rennes - Lyon - Grenoble
D7cisionnel - CRM - KM - e-Commerce
Port du Pont de Saint-Cloud - Face au 9, quai du 4 septembre - 92100
Boulogne
T7l. : 01 55 60 23 00 - Fax : 01 55 60 00 68
http://www.homsys.com - mailto:dmounier@homsys.com


+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---


+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---