RE: Lotus Notes/AS400 Integration

Neil,

There are several ways to get data from your AS/400 to your Lotus Notes   
Server.  If you don't need online, perhaps you may try Data Propagator   
from the 400.

For online data there was an excellent article in the newsletter 'Client   
Access/400 Expert', May/June 1997, volume 4 issue 6, published by   
Midrange Computing.  It went step by step in accessing data from your   
Notes via ODBC.

Examples of a drop down list using the Notes   
@DbColumn("ODBC":"NoCache";"Parts";"";"";"PARTLIST";"ITEM";"Distinct";"Asc  
ending")
into a 'Use Formula for choices' field.

or filling data into a field from a file using
FIELD Info :=   
@DbLookup("ODBC":"Cache";"Parts";"";"";"PARTLIST";"SPECIFICATION";"ITEM";P  
roduct);

Also accessing SQL via the @DbCommand

How to set up the ODBC connection was also included.

Contact:
Client Access/400 Expert
5650 El Camino Real
Suite 225
Carlsbad CA 92008
(760) 931-8615
(800) 477-5665
(760) 931-9935 fax


Rob Berendt, CCP
rob@dekko.com


 ----------
From:  Neil Palmer[SMTP:MIDRANGE-L@midrange.com]
Sent:  Monday, July 28, 1997 11:56 PM
To:  ROB; MIDRANGE-L
Subject:  Lotus Notes/AS400 Integration


Have a situation where a Lotus Notes application is being developed   
(which
will be running on two IBM PC Servers, not on an IPCS/FSIOP) that will
need to be able to access records from a master file & transaction file
on an AS/400.  AS/400 is connected to same TokenRing as the two PC
servers, and we have PC's connected to the same T/R LAN that are using
CA/400 via IPX connection (OS/400 V3R7, CA/400 for Win95 V3R1M2),   
although
there are PC5250 problems we haven't solved yet.
LAN is running Novell Netware 4.1 and we want to use IPX for connection
from Lotus Notes servers to AS/400.
SO - I'm looking for recommendations as to how to have the Lotus Notes
application (which I know next to nothing about) access the files on
the AS/400.  Can Notes just issue an SQL/Query SELECT statement to the
400 ? Is ODBC something to use here ? Anything in CA/400 that could be
used ?  Is there a Lotus Notes 'applet' that can retrieve data from   
AS/400
files ?
Any advice would be appreciated.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
umidr

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *