Re: Free format vs SQL

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: Buck Calabro <Buck.Calabro@commsoft.net>
To: rpg400-l@midrange.com <rpg400-l@midrange.com>
Date: Thursday, September 06, 2001 9:52 AM
Subject: RE: Free format vs SQL


>Perhaps you could propose a standard whereby you wrap the SQL in a
>procedure?  I know; it sounds lame.
>       dow sqlcod=*zeros;
>       count=*zeros;
>       sqlcod=getPllineCount(VDLPO: COUNT)

or at least a subroutine... just not in-line SQL.

and no, the procedure isn't lame, it just requires more lines of code (for
the prototype) and since SQL host variables are global, it sometimes seems
like overkill to use a procedure when a subroutine will do...

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman