Re: SQL

[Mihael Knezevic <m.knezevic@xxxxxxxx>]

i think you can use the CONNECT sql keyword to connect to another database. the 
database should be listed in the rdb directory. you can check that with the 
command WRKRDBDIRE.

On Thu, 16 Sep 2004 06:10:23 -0400
"Mike Silvers" <msilvers@xxxxxxxxxxx> wrote:

> Can I use embedded SQL in an RPG program to connect to a database not on the
> iSeries where the RPG program resides?  In other words....  using embedded
> SQL in an RPG program -- can I open a database according to an IP address
> and run an SQL statement?
> 
> If so -- anyone have an example?
> 
> Thanks
> 
> Mike
> 
> 
> =======================================
> Mike Silvers
> Senior Programmer/Analyst
> iSeries Websphere Certified
> Hainey Business Systems
> Main Office:  (717) 718-9601 ext 237
> Branch Office:  (410) 219-2695
> Fax: (877) 804-9589
> http://www.hbs-inc.com
> AIM:  IBMJavaMan
> =======================================
> 
> 
> 
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 


-----------------------------------------------------------------

   /"\
   \ /
    X            ASCII Ribbon campaign against HTML E-Mail
   / \

-----------------------------------------------------------------