Re: SQL

I think you could create something like this:
 
d returnCode     s                7  0 
d statement      s             2048    
 *------------------------------------------------------
C/EXEC SQL                                                                  
c+ PREPARE sel FROM :statement

C/END-EXEC                                                                  
c                   if        sqlcod = *zero                                
C/EXEC SQL                                                                  
c+ EXECUTE sel                                                              
C/END-EXEC                                                                  
c                   eval      return = sqlcod                           
c                   endif                                                   

 *
c                   EVAL      *INLR = *ON
c                   RETURN
 *------------------------------------------------------
c     *inzsr        begsr             
c       *entry      plist
c                   parm                    return
c                   parm                    statement
c                   endsr  
 
bill
 
 

----- Original Message ----- 
From: John Candidi <mailto:jacandidi@xxxxxxxxxxxxxxxxxxxx>  
To: Midrange Systems Technical  <mailto:midrange-l@xxxxxxxxxxxx> Discussion 
Sent: Thursday, January 18, 2007 11:46 AM
Subject: SQL


Excuse the idiocy in this question. We don't do a whole lot of SQL, usually 
very small updates that I do interactively but I have a large update to do 
and I would like to submit it to batch. How do I go about doing that? 



John A Candidi 

Rutgers Insurance Companies 

IT Director - Iseries Manager 

856-779-2274