#1 - You don't need DB2. If you've got DB2 then you don't need D400 for
data access to it - SQL Links will do that. You do get native access to
files or you can use the IDCO400 driver and use the BDE - which is what I
do cause the native stuff doesn't use TDataset's so you can't use dataaware
controls - only there own versions.
#2 - You can execute programs, batch jobs etc, queues, api calls, files,
tables, sql etc. Just about anything.
#3 - We wish! The CO400 engine installs from the PC onto the 400 and
compiles it'self - but it's not Delphi - it's RPG and it uses the 400 to
compile.
Essestially, the CO400 (or CO404 for D4) engine sits on the 400 and waits
for a connection - much like a socket server does with Midas. It just acts
as a gateway, marshalling data and parameters between the two platforms.
VCL components and some DLL's/BDE drivers manage the PC end.
There have been lots of patches (Patch 31 was the latest for D3, v 4.03 is
the latest for D4). Recently Inprise handed the whole lot over to System
Objects which you can get to via the Inprise Web Site. The patches and
other stuff are now back on the old tcis web site (http://www.tcis.fr).
It's not cheap and you pay a per user and per developer license. If you
only need to suck down some data occassionally then I'd go with ODBC or
IBM's Client Access which comes with a COM interface. If you know RPG and
400's really well then you could probably do the same thing yourself -
given a month or three...
BJ Wilson <[EMAIL PROTECTED]> on 29/04/99 16:53:31
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: RE: [DUG]: Delphi/400
As I understand it, there are three ways to tackle AS400 apps with Delphi.
1. A Delphi app running on NT which connects to a DB2 database on an AS400
(without the ability to execute stored procedures). This is merely a BDE
SQL*Links driver.
2. Same as above, but with the ability to execute stored procedures. I'm
not sure how the specifics of this work.
3. Deplhi400, which compiles an application specifically to be executed on
an AS/400. This is, as far as I know, a whole different flavour of Delphi.
We're currently exploring option #1 above.
Recently (say, four or five months ago) there was a Delphi Informant
article about it. I believe it was the cover story, but I can't seem to
find it now. Back in May 1998 there was an informant article on executing
AS400 applications using TQuery instead of an RPC or FTP.
And that's about all I know. Have you checked the Borland website? Last I
looked the details were sketchy.
Cheers.
BJ...
----------
From: Patrick Dunford[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, 29 April 1999 15:33
To: Multiple recipients of list delphi
Subject: [DUG]: Delphi/400
Where do I find out information about Delphi/400 and the AS400 platform?
============================================
Patrick Dunford, Christchurch, NZ
http://patrick.dunford.com/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
