Re: fuel meter data from pc to as400 (Corrected ??)

Jim,

        Sounds like a perfect fit for NFS if you have all the servers and
the iSeries on a common LAN/WAN so that the TCP/IP NFS connection can be
made.  Your iSeries code would just read the "Export" files with RPG code
and process the results.

        JMS...

----- Original Message -----
From: "Jim Franz" <franz400@triad.rr.com>
To: <midrange-l@midrange.com>
Sent: Sunday, May 05, 2002 12:34 PM
Subject: Re: fuel meter data from pc to as400 (Corrected ??)


> >You really have not given us enough background...
>  Sorry, was trying to be brief.
> The database is ascii text or Paradox (apparently supports both).
> This is a purchased packaged system, wireless fuel meters and
> pc server software. Very rugged-picture Buffalo, NY Airport in January.
> Server software comms with wireless, a creates tran files/history to
> what they called "export files", with no user intervention other than
> wireless users (could be many). You come and get the data. CIO does not
> want to reinvent the server software on the 400, just get the data
> in as close to real-time as possible.
> Only specs about wireless protocol is "spread spectrum", and unit
> stores transactions, so if out of range, will sync up when back in
> range. Was handed this Friday at 4pm and told to have "game-plan"
> by late Monday.
> thanks for your comments
> jim franz
>
> ----- Original Message -----
> From: "Jeff Silberberg" <jsilberberg@mindspring.com>
> To: <midrange-l@midrange.com>
> Sent: Sunday, May 05, 2002 11:45 AM
> Subject: Re: fuel meter data from pc to as400 (Corrected ??)
>
>
> > Jim,
> >
> >         You really have not given us enough background on the design
here
> an
> > I guess my first question is what role do the PC servers play ?  The
> second
> > question would be what is the database on the PC servers, is it flat
ASCII
> > or is it Relational, (UDB/2, MS -SQL, Oracle, ect).. The next question I
> > guess would be why are the PC servers there at all, you say it's a
> Wireless
> > Network but not what kind. A standard CISCO Aironet 802.11B could be
> linking
> > a Radio Device to the iSeries just as easily as the PC while a Private
> Radio
> > System like SmartNet or EDACS have other issues in terms of the
interface
> > protocol.
> >
> >         Anyway, if this were my headache I would look at:
> >
> >         NFS -- Export the PC Disk and then do an IMPORT on the iSeries.
> Now
> > the disk is available on the iSeies to be properly opened.
> >
http://searchwin2000.techtarget.com/sDefinition/0,,sid1_gci214121,00.html
> >
> >         Integrated xSeries or HLS to xSeries with shared iSeries DASD,
> again
> > now the disk is available natively to the iSeries to be properly opened.
> >
> >         If the PC is running a relation engine like UDB/2 maybe you have
a
> > remote journal or other feature that can do this..
> >
> >         MQSeries - Have the application provider place a transaction
copy
> > into MQ for processing on the iSeries...
> >
> >         Home Grown Socket based Program to Program code to do what's
> > necessary...
> >
> >         DO NOT USE CAE for any of this if the providers code is doing
> direct
> > radio I/O as the interrupts and conflicts, not to mention system load,
> can
> > get you in BIG  trouble from a reliability standpoint...
> >
> >         Good Luck,
> >         JMS..
> > ====================
> > Jeffrey M. Silberberg
> > CompuDesigns, Inc.
> > Atlanta, Ga. 30350-5640
> >
> > ----- Original Message -----
> > From: "Jim Franz" <franz400@triad.rr.com>
> > To: <MIDRANGE-L@midrange.com>
> > Sent: Saturday, May 04, 2002 10:38 PM
> > Subject: fuel meter data to pc to as400
> >
> >
> > > This is a multi-part message in MIME format.
> > > --
> > > [ Picked text/plain from multipart/alternative ]
> > > Looking for ideas or products to keep pc ascii text data real-time
> > > automated updated to as400. We are looking at AVTRAC fuel meters
> > > doing wireless update to pc with their software. We want to do
> > > unattended update to as400 so counter sales can immediate invoice.
> > > This at over 20 locations wide area network.
> > > Any other Aircraft Fuel Meters? I can see ftp but pc would need
> > > server software (maybe in W2K?). Am familiar async/bysync but
> > > not pc side.
> > > jim franz
> > >
> > > --
> > >
> > >
> > > _______________________________________________
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > > To post a message email: MIDRANGE-L@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@midrange.com
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>