Re: Free format SQL

Free format SQL became available in V5R4.
There's nothing to the syntax except you have a EXEC SQL in front and a
semi-colon at the end of every statement.
E.g.
EXEC SQL UPDATE DEPARTMENT SET MGRNO = :MGR_NUM WHERE DEPTNO = :INT_DEP;

Hope this helps.

Glenn Gundermann
ggundermann@xxxxxx
Cell: (647) 272-3295

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