Re: Navigator question

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

<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.
> >
> >
> >