Re: SQLRPGLE program giving strange message in joblog

The query options file can be duplicated into QUSRSYS from QSYS I
believe. This allows you to modify how SQL performs, etc.

Your update program needs to be compile with commitment control *none
or preferably insert an SQL statement at the beginning of the program
like this:

c/exec sql
c+ set option commit = *none
c/end-exec


This allows the program to operate with out commitment control on and
the programmer does not have to remember to changes this everytime the
program is compile.

Regard,
Russell Conerly
Artaban Solutions

-------------------
> (OS400 V4R4)  I've got an SQLRPGLE program which I'm trying to use
to 
> update a file.  I'm getting the following in my job log:
> 
>                          Additional Message Information  
>   
>  Message ID . . . . . . :   CPI433A  
>  Date sent  . . . . . . :   08/17/01      Time sent  . . . . . . : 
> 15:20:05 
>   
>  Message . . . . :   Unable to retrieve query options file.  
>   
>  Cause . . . . . :   Unable to retrieve the query options from
member 
> QAQQINI 
>    in file QAQQINI in library QUSRSYS for reason code 2.  The reason
codes 
> and 
>    their meanings follow:  
>      1 - Library QUSRSYS was not found.  
>      2 - File QAQQINI in library QUSRSYS was not found.  
> 
> 
> What is the QAQQINI file?  The update works if I key the update
statement 
> in using STRSQL, but fails when I run the same statement from my
program.
> 
> Thanks!
> 
> Tom Hightower
> Solutions, Inc
> http://www.simas.com
> ------------
> If Bill Gates had a dime for every time a Windows box crashed... oh,
wait 
> - he does.