RE: Communications Questions

["John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>]

SQL and a DRDA connection using commitment control?

John Brandt
iStudio400.com
(903) 523-0708
Home of iS/ODBC - MSSQL access FROM iSeries.

-----Original Message-----
From: Mike Silvers [mailto:msilvers@xxxxxxxxxxx]
Sent: Wednesday, September 15, 2004 3:53 PM
To: Midrange-L list
Subject: Communications Questions


All,

I am looking for some ideas.  Let me explain the problem.  We have an
iSeries located in a building, lets call this iSeries A.  We have another
iSeries located in the main office.  Lets call this iSeries B.  iSeries A is
used to process information about the sales of cars.  iSeries B has web
services running on the machine and processes a subset of a file from
iSeries A.  We have a trigger for the file on iSeries A that will process
only the records that are needed for this process.  The trigger program
saves the information we need to a hold file.  What we need to do is
transfer the information in the hold file to iSeries B either in real time
or near real time.  The file must be transferred over the internet, so DDM
is out of the question (there are too many issues with error recovery when
the communications go down in DDM).  We were kicking around the idea to FTP
the file, but this must be all automated.

Any ideas on a solution?

Thanks...



=======================================
Mike Silvers
Senior Programmer/Analyst
iSeries Websphere Certified
Hainey Business Systems
Main Office:  (717) 718-9601 ext 237
Branch Office:  (410) 219-2695
Fax: (877) 804-9589
http://www.hbs-inc.com
AIM:  IBMJavaMan
=======================================




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.760 / Virus Database: 509 - Release Date: 9/10/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.762 / Virus Database: 510 - Release Date: 9/13/04