Teraspace, SQL, RPG

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

Attached is a small embedded sql program, to pass back a result set... Via a
stored procedure...

But It's limited, to the MODS limitation for the number of records I can
pass back...  I was wondeing, if I created a pointer (teraspace) can I pass
the pointer with a occurance count, to bypass the limit?  Or can I only use
a MODS...

d   i             s              5  0                   
                                                        
/* create the result set.                               
d resarray        ds                  occurs(5)         
d   field1                       5  0                   
d   field2                      15                      
d   field3                       9  2                   
                                                        
 /* row counter                                               
 c     1             occur     resarray                       
 c                   eval      field1 = 123                   
 c                   eval      field2 = 'tim'                 
 c                   eval      field3 = 12345.12              
 c     2             occur     resarray                       
 c                   eval      field1 = 321                   
 c                   eval      field2 = 'tim2'               
 c                   eval      field3 = 54321.21              /*

c                   eval      i = 2                   
/*                                                    
c/exec sql                                            
c+ set result sets array :resarray  for :i rows       
c/end-exec                                            
c                   return                            

------------------------------------------------------------------

Thanks tim

This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.