|
We too, at CMI, have been successful with the DataQ and ASP approach to AS/400 integration. Although very successful, we've been replacing it with TCP/IP sockets. Since OS/400 V4 and the Unix type APIs were delivered the performance has been remarkable and RPG programming changes have been reduced. To check out a easier set of ActiveX CA/400 aware objects, check out http://www.cm-inc.com/AS400ole/ which include much more AS/400 support than DataQs. An optimized SQL is included to directly reference the cwbOBJ.dll without ODBC and quickly processes records in a read-only mode, thus the DB2 administrator may allow the ASP programmer to use it in the first place. Spoolfiles and Spoolfile lists create dynamic Web pages with original reports straight from the output queues. Calling programs with parameters and execute OS/400 commands is in there as well. But be careful as the command PWRDWNSYS *IMMED can be run from a Microsoft sponsored Web page... Doesn't that send chills up a midranger's spine. Check out http://www.cm-inc.com/login/index.asp for an example of what we have done. Choose demonstrations and see a Web based hotel reservations system and a B2B solution featuring Spoolfiles and Excel downloads. Keep in mind that only Web pages and images are stored on the NT platform and all the data comes from the AS/400. Our AS/400 is a model 170 with 256meg of memory. IBM may not get much revenue from this solution. Most of our customers can't afford the horse power required to sponsor an AS/400 only based solution. I've created an article called 'Using the IBM AS/400 with Microsoft Internet Information Server', This document is available on-line at http://www.cm-inc.com/WhatsNew/UsingIIS.htm and should help AS/400 IT staff become more aware of these types of solutions, especially if ActiveX is something new to them. Ken Slaugh (707) 795-1512 x118 Chouinard & Myhre, Inc. AS/400 Professional Administrator/MSE Client Access Specialist http://www.cm-inc.com/ Pete Hall <pbhall@execpc.com> To: MIDRANGE-L@midrange.com Sent by: cc: owner-midrange-l@mi Subject: RE: Web to AS/400 Database drange.com connectivity 08/02/00 06:02 PM Please respond to MIDRANGE-L At 08:32 08/02/2000 , Art Tostane wrote: >I'm aware of the Asna product. The app that we are writing is written >using Lansa. One of the web >companies bidding is using the Lansa product, so there are no >problems. I'm interested in options >that are more "standard". These web guys are talking about using things >such as Cold Fusion, etc. Although I am also very impressed with AVR and the ease with which you can get data on and off of the AS/400 with it, you might also look at data queues in conjunction with ASP. The data queue control in the 5250 toolbox is a slam dunk to use and very fast. It's almost as fast and easy as using AVR and passing data back and forth as parameters. Either one of these methods have the added advantage of allowing you to control what goes on and comes off of your box, because you own the server piece. I would be reluctant to open up my system to software that I can't control, and about the only other option I know of is ODBC, which is very difficult to keep tabs on, slower and more resource intensive too. If you own the server, you can write code that takes advantage of what you know about your database. It not only keeps control in house where it belongs, but it makes the presentation more efficient, quicker, and less error prone. Everything I've read lately recommends a clear delineation between the presentation and business logic layers. That's one of the reasons I'm working with AVR, ASP, and AS/400 server applications to generate XML. The presentation layer is completely decoupled from the database. The web guys can make things pretty, but I get to control the data. It's quick too. XML isn't ready for use on the outside yet, although if you have a 6-8 month delay for development, it'll be a lot more common. My "customers" are all internal. If you do use XML, to some extent you'll probably end up proselytizing for Microsoft, because they appear to be the main consumer vendor that's supporting XML in a big way. Fortunately it's a vehicle that's worth supporting. Check out the SOAP protocol if you doubt it's going to fly. Pete Hall pbhall@execpc.com http://www.execpc.com/~pbhall +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
