RE: Free format vs SQL

["Bartell, Aaron L. (TC)" <ALBartell@xxxxxxxxxxxxxx>]

I really like how Java does this.

SQLString = 'SELECT * FROM LIB/FILE WHERE CUSTNO=' + CustNo

Statement stmt = con.createStatement(); // create the statement on the 400
ResultSet rs = stmt.executeQuery(sqlString); // execute the statement on the
400

         while (rs.next()) // process result set
         {
           System.out.println(rs.getInt("CUSTNO"));
         }
So in the new free format RPG you cannot have the SQL free format?

You know there is a lot that RPG could learn from Java.  And in the same
breath vice versa:-)

Aaron Bartell

-----Original Message-----
From: R. Bruce Hoffman, Jr. [mailto:rbruceh@attglobal.net]
Sent: Thursday, September 06, 2001 9:00 AM
To: rpg400-l@midrange.com
Subject: Re: Free format vs SQL


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



_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.