RE: Sample Free Form RPG program w/embedded SQL

Usually I drop all my SQL portions into either subprocs or subroutines
to keep the code pretty.... 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of HauserSSS
Sent: Thursday, September 08, 2005 2:09 PM
To: RPG programming on the AS400 / iSeries
Subject: AW: Sample Free Form RPG program w/embedded SQL

SQL must be embedded into fixed format coding.
That means, you have to end free format coding, enter your embedded SQL
statement and restart free format coding again:

 /End-Free
C/EXEC SQL  Set :MyWeek = Week_Iso(:MyDate) C/END-EXEC  /Free

Birgitta

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Condon, Mike
Gesendet: Donnerstag, 8. September 2005 20:37
An: RPG programming on the AS400 / iSeries
Betreff: Sample Free Form RPG program w/embedded SQL


Can someone send me a short, simple Free Form RPG program w/embedded
SQL?

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



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