Re: How do dey do it? (DBU and off-sysem databases)

[jim t <jim_t_59@xxxxxxxxx>]

If you are talking abour Prodata's product, then you will need RDB connect.

You start with creating a connection with a JDBC driver - this will create a program that contains the JDBC connection parms, userid, password, etc.

After the connection is created you can either use RDB Connect and SQL statements to download from the remote system, or use Prodata's DBU to view/change the remote data, or write RPG programs that include SQL statements to access the remote data. 

Works great for us, with the exception of the connection to Sybase - not a RDB Connect issue, more an issue with "set rowcount" in Sybase.

For more info:
http://www.prodatacomputer.com/documentation/RDBConnect/RDB_Connect.pdf



Jim

--- On Tue, 12/11/12, James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx> wrote:

> From: James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx>
> Subject: How do dey do it? (DBU and off-sysem databases)
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Received: Tuesday, December 11, 2012, 6:20 AM
> I was recently shown an ad for DBU,
> touting a new feature involving 
> access to off-system data across a network.
>
> Anybody know how they do this, and how extensive the
> capability is?
>
> --
> JHHL
> -- 
> 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.