RE: Free format SQL

Bruce Hoffman is covering this topic at RPG World in May, but from what I saw in
his pitch, (if memory serves) it is something like this:

 /free 

   // your normal freeformat stuff.

     Exec-sql;
         Your SQL statements. End with a semicolon.

  // done.

No /end-exec from what I remember.
I think the way it works is that EXEC-SQL starts embedded SQL and you follow it
with your SQL statement. Terminate them with a semicolon. 

I'll ask Bruce to respond if he has time.

-Bob Cozzi
www.RPGWorld.com



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On
Behalf Of Jeff Young
Sent: Tuesday, February 13, 2007 3:11 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Free format SQL

When did Free Format SQL become available in RPGLE and where can I find the
syntax for it?
I have searched the infocenter for V5R4 and the only examples that I can find
are still in the old format.

Thanks,
 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer
V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3


 
________________________________________________________________________________
____
Get your own web address.  
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL