SQL command

[kcordova]

The file I'm updating does not need to be journal. But my SQL is failing because the file is not journalled. Could someone help me with the sql command to correct this problem.

Thanks in advance.

 

[rstitzel]

I think it would be

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

 

[tagrove]

Compile the program with the following options:

COMMIT(*NONE) CLOSQLCSR(*ENDMOD)

This turns off the commitment control issue you mentioned, but also closes the cursors when the program ends.

 

[iSeriesCodePoet]

I would recommend this. This is close to the first example.

    C/EXEC SQL                        
    C+ Set Option                     
    C+     Commit    = *NONE,         
    C+     CloSqlCsr = *ENDMOD        
    C/END-EXEC

I would recomend this way over tagrove's way because then you have to remember to set the compile options everytime, this way you don't have to worry about that.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

http://www.spreadfirefox.com/?q=affiliates&id=2483&t=1