SQL vs. traditional I/O?

["Smith, Dave" <DSmith@xxxxxxxxx>]

Joe:

1. There is no need to use a cursor for this type of process.  That's
probably slowing us down.   I'll test this weekend if I have a moment.

2. The * operation "Select *", I'm told, slows things down as opposed to
listing specific field names.   Again, not positive, but I will check.

I'm interested in your new IAAI site but wonder if it is going to take
this type of discussion away from Midrange-L?

C                       for       x = 1 to count    
C                 eval      mykey = %char(x)  

C/EXEC SQL                   
C+ SELECT       FIELD1, FIELD2, Field3       
C+              INTO :wField1, :Field2, :wfield3
C+                  where key1 = :mykey
C/END-EXEC
C                       endfor

David J. Smith
IT Contractor
dsmith@xxxxxxxxx
517.546.5400 Ext: 1513


                /EXEC SQL declare c cursor for select * from j4pp1 where
key1 = :mykey 
                c/END-EXEC

                c/EXEC SQL open c

                c/END-EXEC

                c/EXEC SQL fetch from c into :j4pp1

                c/END-EXEC

                c/EXEC SQL close c

                c/END-EXEC