RE: SQL interactive on as/400 session

Hi,

If you do a strsql and execute an update statement, and do a

shift+sysreq+2 

before it ends, does it update any records?

Are your tables/file registered in a journal?
Is Commitment Control in the STRSQL-Command (or F13 / 1. / CMTCTL) set to a
value other than *NONE ?

If the second or both questions must be answered with NO, the rows updated
before the abnormal end stay changed. 

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"



-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Jay Vaughn
Gesendet: Friday, February 09, 2007 17:48
An: rpg400-l@xxxxxxxxxxxx
Betreff: SQL interactive on as/400 session


If you do a strsql and execute an update statement, and do a shift+sysreq+2 
before it ends, does it update any records?
 
 
 
 
 
Thanks,
 
 
Jay Vaughn
iSeries Senior Programmer/Analyst
RateWatch
jayv@xxxxxxxxxxxxxx
251-633-8929