say 'G2SELECTBLOB RESULT 1 (SQ5 Value)='g2selectblob(sq5, 'PHOTO1.GIF')
say '---elapse ='time('R')
say
say 'G2SELECTBLOB RESULT 2 (SQ5)......='g2selectblob('sq5', 'PHOTO2.GIF')
say '---elapse ='time('R')
say
say 'G2SELECTBLOB RESULT 3 (value)....='g2selectblob("SELECT picture from emp_photo where empno = '000130' and translate(photo_format) = 'GIF'", 'PHOTO3.GIF')
say '---elapse ='time('R')
say
say 'Retrieving (using SQ5 Value) 100 times...'
do 100
call g2selectblob sq5, 'PHOTO4.GIF'
end
elapse = time('R')
say '---elapse ='elapse '(total), 'elapse / 100 '(per call on average)'