Return Result Set - V5R4

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Do I need to use a MODS to return a result set from an RPG program
(V5R4) or can I use arrays within a DS? IOW, if I use this:

Exec SQL SET RESULT SETS ARRAY :MyReturnData FOR :MyCount ROWS;

Can MyReturnData be this:

     D myReturnData...
     D                 DS
     D   WOArray                           Dim(100)
     D     WOTran                    16  0 Overlay(WOArray)
     D     WOINVTH                    2  0 Overlay(WOArray:*Next)
     D     WOMA                         1     Overlay(WOArray:*Next)

Or does it have to be this:

      DMyReturnData...
      D                DS                  Occurs(100)
     D     WOTran                    16  0
     D     WOINVTH                    2  0
     D     WOMA                         1
     D     WOINVT                     2

Thanks!