AW: SQL in RPG

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

> > Find and download the Redbook (SG24-6393-00) iSeries Application Data 
> > Access.  Birgitta, Sharon, et al, did a fantastic job.

Thanks a lot

And here is the link:
http://www.redbooks.ibm.com/abstracts/sg246393.html?Open

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Jerry Adams
Gesendet: Friday, April 18, 2008 18:29
An: RPG programming on the AS400 / iSeries
Betreff: Re: SQL in RPG


Most things are until you try.  I had a heck of a time learning to ride 
a bicycle until Aunt Pauline gave me a push.

Find and download the Redbook (SG24-6393-00) iSeries Application Data 
Access.  Birgitta, Sharon, et al, did a fantastic job.

	* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
	615.995.7024
fax
	615.995.1201
email
	jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



pepitovadecurt wrote:
> Hi, I never include an SQL query into a RPG program.
> I have the table PIEZAS with 2 rows (NUMERO, NOMBRE), I want to select
> the PIEZAS.NUMERO=152 and print it, how I have to include the sql query 
> into an rpg program? And declare the table?
> I have see a few examples in internet but are too complex.
>
>