Re: Accessing SQl files by a RPG program or something else ?
- From: Kent Milligan <kmill@xxxxxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 15:41:32 -0500
I don't mind you recommending a non-IBM solution to the problem. However, if
your going to use negative marketing to hype an alternative solution than you
better have your facts straight.
1) DB2 Connect does not support the access of SQL Server tables, only DB2. You
would need to get WebSphere Information Integrator.
2) An embedded CONNECT statement is NOT required. IBM offers an ILE API set
known as the SQL Call Level Interface (CLI), thus industry standard SQL
interfaces can be used - doesn't matter if it's embedded or API-based.
3) The price of DB2 Connect can be an issue for some customers, IBM is
considering a special iSeries package with a lower price point.
> IBM offers an extremely expensive DB/2 Connect that runs on and NT
> server and allows your AS/400 to access tables from many different
> vendors through the DRDA interface (this means your HLL program must use
> the CONNECT TO.... embedded SQL statement)
>
> RJS software offers a much cheaper solution that runs on and NT server
> and provides an ILE api (tailored with the RPG programmer in mind) that
> allows your AS/400 to connect to any ODBC database.
>
> "Peter Wensink" <pwensink@xxxxxxxxxxxx> wrote in message
> news:4314bbd3$0$20268$19deed1b@xxxxxxxxxxxxxxxxxxxx
> > Hi,
> >
> > I like to access both AS/400 and SQL files by a AS/400 program like
> > RPG at
> > the same time, is this possible ?
> >
> > Or by websphere ?
> >
> > Thanks a lot, regards,
> >
> > Peter.
> >
--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
kmill@xxxxxxxxxxxxxxxx (spam trick) GO HAWKEYES!!
>>> www.iseries.ibm.com/db2
(opinions stated are not necessarily those of my employer)
.
- Follow-Ups:
- Prev by Date: Re: Where to store SQL Triggers
- Next by Date: Re: list of libraries containing output queues
- Previous by thread: Re: how does sql create procedure work?
- Next by thread: Re: Accessing SQl files by a RPG program or something else ?
- Index(es):
Relevant Pages
|
