SQL and Commitment control

["J Michael Smith" <Michael.Smith3@xxxxxxxx>]

Follow up:
 
I changed the STRCMTCTL CMTSCOPE       *JOB(in test) and retried.  Worked fine. 
 However making this modification inproduction is not an option.
 
Michael  

 
I have a driver CL program that does a STRCMTCTL  LCKLVL(*CHG)
 
I compiled a program with embedded SQL statements with:
             
Commitment control . . . . . . .   *CHG
 
When ever the program is executed I receive the following error:
CPF4326    Escape                  50    01/31/03   13:59:38   QDBSIGEX      
                                     To module . . . . . . . . . :   AI7704RP
                                     To procedure  . . . . . . . :   AI7704RP
                                     Statement . . . . . . . . . :   1000001 
Message . . . . :   Commitment definition *N not valid for open of BLEGRPL0.    
     
Cause . . . . . :   Commitment definition *N is not valid for open of member    
     
  BLEGRPL0 file BLEGRPL0 in library BOSS for one of the following reasons: --   
     
  Member BLEGRPL0 was opened for commitment control when commitment definition  
     
  *N was not active. -- Uncommitted changes are pending for member BLEGRPL0     
     
  for a commitment definition other than *N. -- The calling program is using    
     
  commitment definition *N which has a scope of *ACTGRP, while the program      
     
  specified to open the file using a scope of *JOB. Recovery  . . . :   Do one  
     
  of the following and try your request again. -- For the first case, use the   
     

 
I tried recompiling with a *NONE, same error.
 
Any suggestions on how to resolve this would be appreciated