DB2 on AS400

Y. Makarounis

Delphi Developer

Tue, 17 Jun 2003 01:22:06 GMT

DB2 on AS400

I am looking for information on accessing DB2 on an AS400 server from D5
enterprise. Any suggestions will be very helpful.
Thanks
Yannis

Justin Pitt

Delphi Developer

Tue, 17 Jun 2003 01:29:33 GMT

Re:DB2 on AS400

We have used the ADO provider for DB2/400 from MS with a great deal of
success. It is provided as a part of the MS Host Integration Server client
install. Good Stuff.

With less success, the ADO provider from IBM in the Client Access Express
package which I believe is d/l-able from IBM.
Another option is to use the MS ADO provider for ODBC drivers against a
Client Access DSN.

Delphi Developer

Tue, 17 Jun 2003 13:54:00 GMT

Re:DB2 on AS400

In addition, I've been using EasyCom (http://www.easycom-aura.com - a French
company) with a lot of success for the past 3 years. It's a bit pricy, but
it also doesn't require more than Delphi Professional version. It's
completely transparent - just another BDE driver. I find it a bit slow
though - or is it our AS/400 or Accountants running insanely long reports as
usual ;-).

What happened with Delphi/400?

Justin Pitt

Delphi Developer

Tue, 17 Jun 2003 22:30:07 GMT

Re:DB2 on AS400

Delphi/400 I THINK was subsumed by www.systemobjects.com Both that and
easycom require subsystem installs on the 400. Neither Client Access or Host
Integration Server do.
disclaimer: I've used EasyCom and ACE 400 - didn't like 'em.

Tom Chamberlai

Delphi Developer

Sun, 22 Jun 2003 12:29:58 GMT

Re:DB2 on AS400

I have used SystemObjects for a few years and have not had any problems.
Have not tried EasyCom or ACE..... But I know anything has to be better
then the Client Access ODBC connection....

P.S.
Client Access and Host Integration do have Subsystems....
QSERVER and QSYSWRK, they are just used by other things as well.
And having it's own Subsystem is not a bad thing, better memory management.

--
Thomas Chamberlain, tcham...@3x.com
AS/400 & Delphi Consultant
3X Corporation
Web and Systems Integrators
Worthington, Ohio USA
www.3x.com

Quote

"Justin Pitts" <pitt...@my-deja.com> wrote in message

news:3a4c9fe8_1@dnews...

Quote

> Delphi/400 I THINK was subsumed by www.systemobjects.com Both that and
> easycom require subsystem installs on the 400. Neither Client Access or
Host
> Integration Server do.
> disclaimer: I've used EasyCom and ACE 400 - didn't like 'em.

Justin Pitt

Delphi Developer

Sun, 22 Jun 2003 21:41:05 GMT

Re:DB2 on AS400

I was under the impression that those subsystems were already there on the
400.

The Client Access Express is a bit better than the ODBC, and HIS 2000
substantially so.

Justin Pitt

Delphi Developer

Sun, 22 Jun 2003 21:43:05 GMT

Re:DB2 on AS400

PS why isn't there more representation from Columbus!

Tom Chamberlai

Delphi Developer

Mon, 23 Jun 2003 13:03:46 GMT

Re:DB2 on AS400

If you start TCP/IP Services, Client Access Services... You get QSERVER.
This is where all ODBC/Client Access Services communicate thru.

How do you know what user is really running those QZD* jobs that report
the user as "QUSER"? WRKODBCJOB

Justin, you in/from Cowtown?

--
Thomas Chamberlain, tcham...@3x.com
AS/400 & Delphi Consultant
3X Corporation
Web and Systems Integrators
Worthington, Ohio USA
www.3x.com

Quote

"Justin Pitts" <pitt...@my-deja.com> wrote in message

news:3a532be4$1_2@dnews...

Quote

> I was under the impression that those subsystems were already there on the
> 400.

> The Client Access Express is a bit better than the ODBC, and HIS 2000
> substantially so.

Justin Pitt

Delphi Developer

Mon, 23 Jun 2003 22:40:37 GMT

Re:DB2 on AS400

QSERVER is a part of OS/400, isn't it (Speaking as a PC guy who is starting
to get confused, not as a 400 guru)? ACE400 and systemobjects both require
you to install THEIR software in the 400 (and an expensive maintenance
contract, IIRC)

Yeah, I live in Columbus - I work for Consolidated Stores(*) over on the
west side.
Know any good Domino consultants?

(*) Odd Lots/Big Lots/MacFrugals/PicNSave/Formerly KB Toys

Tom Chamberlai

Delphi Developer

Tue, 24 Jun 2003 08:39:57 GMT

Re:DB2 on AS400

We will not get into a Job Queue to Sub Systems to Machine Pools
discussion....

ACE/400 and SystemObjects both install software on the AS/400.
Client Access is a Licensed program from IBM, you do not
have to install it, but that would be like Microsoft not installing
Outlook Express, even if you already have Outlook 2000.

And yes, we do have Domino Consultants....

Do you use Delphi at Consolidated Stores?
You would not know it from our out-of-date
web site...

But we (3X Corporation) do have people doing Delphi!

--
Thomas Chamberlain, tcham...@3x.com
AS/400 & Delphi Consultant
3X Corporation
Web and Systems Integrators
Worthington, Ohio USA
www.3x.com

Quote

"Justin Pitts" <pitt...@my-deja.com> wrote in message

news:3a548b57$1_1@dnews...

Quote

> QSERVER is a part of OS/400, isn't it (Speaking as a PC guy who is
starting
> to get confused, not as a 400 guru)? ACE400 and systemobjects both require
> you to install THEIR software in the 400 (and an expensive maintenance
> contract, IIRC)

> Yeah, I live in Columbus - I work for Consolidated Stores(*) over on the
> west side.
> Know any good Domino consultants?

> (*) Odd Lots/Big Lots/MacFrugals/PicNSave/Formerly KB Toys

Justin Pitt

Delphi Developer

Wed, 25 Jun 2003 06:09:49 GMT

Re:DB2 on AS400

Quote

"Tom Chamberlain" <tcham...@columbus.rr.com> wrote in message

news:3a5517eb_1@dnews...

Quote

> We will not get into a Job Queue to Sub Systems to Machine Pools
> discussion....

Why not? :) What's a Machine Pool? Never heard of that.

Quote

> ACE/400 and SystemObjects both install software on the AS/400.
> Client Access is a Licensed program from IBM, you do not
> have to install it, but that would be like Microsoft not installing
> Outlook Express, even if you already have Outlook 2000.

--Kinda-- the way I understood it to be.