RE: SQL newbie question / Exec SQL "SET"... -- RPG400-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: RE: SQL newbie question / Exec SQL "SET"...
From: "Gottlieb, Mike" <MGottlieb@xxxxxxxxxxxxxx>
Date: Fri, 8 Jul 2005 11:24:31 -0400
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

What other options can be set in the "SET OPTION" command?

Gottlieb, Michael       
Scholastic, Inc.

        
 

|-----Original Message-----
|From: Holden Tommy [mailto:Tommy.Holden@xxxxxxxxxxxxxxxxx] 
|Sent: Friday, July 08, 2005 11:08 AM
|To: RPG programming on the AS400 / iSeries
|Subject: RE: SQL newbie question
|
|compile the program with COMMIT(*NONE) 
|
|OR
|
|in your program set the option:
|
|C/exec sql
|c+  Set Option Commit=*None
|c/end-exec
|
|Thanks,
|Tommy Holden
|

Follow-Ups:

RE: SQL newbie question / Exec SQL "SET"... , rob

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.