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

--
--
[ Picked text/plain from multipart/alternative ]
I hate to keep beating a dead horse.  I know folks here consider Visual Age
RPG to be a useless product.  However:

It is easy to write a Visual Age RPG program that will reside on the PC.
The program would have 2 files  -  The ascii txt program-described file and
your AS/400 PF (connected via DDM so its reasonably secure).  The program
could have a timer event, and every few seconds it would poll for new data.
New data would be written to the AS/400 with the WRITE opcode.

It could easily have a GUI panel on the PC with full instructions and
whatever else is needed, like Meter-number, etc.

The whole program and run-time would be 10 to 15 megs in size - easily
fitting on any Pentium machine.





---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------

-------Original Message-------

From: midrange-l@midrange.com
Date: Sunday, May 05, 2002 12:26:54
To: midrange-l@midrange.com
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.


.
--
[ Content of type image/gif deleted ]
--