Re: Navigator question

<verndor response>
Thanks, Luis!

Connecting to any database with RUNSQLSTM or with embedded SQL requires an RDBDIRE be defined - and have a DRDA provider for that database. These are like ODBC in the world outside DB2 for i. No non-DB2 RDBMS has one other than Oracle. Just like ODBC, these providers work only for the flavor of database that they're made for.

So we have a product called RPB2SQL Integrator that lets you connect to non-DB2 (well, it could go there, too) SQL-ish database systems. It's a software development kit - a SRVPGM with procedures for doing all the work. IBM has something like this, too, and much more expensive. And there are Java solutions you can code yourself, which'd be free but require learning a different code skill.

All our examples are in RPGLE ( a few in ILE COBOL). I've never tried doing anything directly in ILE CL - easier to manage everything in RPG, in my opinion. But a CALLPRC and CALLP aren't all that different, mayhaps.

If interested, give a call at 888.RJS.SOFT or email me directly about a quick demo.
</verndor response>

Luis Rodriguez wrote:

Well, Most of the times you can connect to a DB2 table without problems....
(Sorry, could not resist :-) )

Seriously, I think that there are some products than can allow you to do
that (Time for a vendor response).

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Mon, May 24, 2010 at 4:51 PM, Lance Gillespie <LGillespie@xxxxxxxx>wrote:

Is it possible to connect to a non-db4 table in the
'run SQL scripts' interface?

It would be nice to be able to use this to update
other tables from db4 data (and maybe vice versa).

Thanks,
Lance

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.