Re: Embedded SQL

Hey Ron,

I have a couple of samples at http://www.rpgnext.com/codesamples/
- SFL_TEMP.RPG is a subfile example that uses SQL.
- TAZMAPSRV.RPG is a "RPGBean" sample:  an encapsulating service program
that uses SQL

Check out these articles too:
http://www.itjungle.com/fhg/fhg072104-story01.html
http://www.itjungle.com/fhg/fhg011205-story01.html
http://www.itjungle.com/fhg/fhg030205-story01.html

They all have an element of embedded SQL, especially the last one.

Also, the "RPGBean Creator" is now open source, so you can download it
at http://www.rpgbeans.com and get some examples from there as well.

HTH,

Joel Cochran
http://www.rpgnext.com
http://www.rpgbeans.com 

On Thu, 2005-05-12 at 12:07, RPower@xxxxxxxxxx wrote:
> Guys,
> fellow developer here is learning SQL.
> Whilst the book he is using is technically and shows us all the nice 
> little things, it fails to show the entire picture.  Would someone out 
> there be willing to share a program using SQL so that we might look at a 
> real example?  TIA,
> 
> Ron Power
> Programmer
> Information Services
> City Of St. John's, NL
> P.O. Box 908
> St. John's, NL
> A1C 5M2
> Tel: 709-576-8132
> Email: rpower@xxxxxxxxxx
> Website: http://www.stjohns.ca/
> ___________________________________________________________________________
> Success is going from failure to failure without a loss of enthusiasm. - 
> Sir Winston Churchill