Is it really sure that nothing else deleted the file (for example a CLRPFM
in a different program or sub-procedure).
Did you check the SQLCODE or SQLSTATE immediately after the Delete
Statement?
What SQLCODE is returned ?
How many records are deleted --> Check SQLERRD(3) or SQLER3.
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!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of joe
Sent: Dienstag, 23. Januar 2018 04:42
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL DELETE with file not journaled
Team,
Why is it that we are able to SQL delete records against a file that is NOT
journal and program compiled with default COMMIT = *CHG and no SQL SET
statement in program and no WITH NC. In addition, after running the program
with all records being deleted we then run same program against file with
now 0 records we then get the message file must be journaled. Why didn't
we get this message the first time???
Thanks
joe
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
