Dieter,
Commit is not in use - typical of our what we do here.
Our tables are journaled, so I guess I look for an entry type to show SQL SELECT/READ against the two tables,
but a quick scan of "All journal entries by code and type" did not reveal an entry type for that ?
Thank you, I will work to capture journal entries within a few minutes of the date/time of the transaction.
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of D*B
Sent: Wednesday, July 15, 2015 10:19 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Unexpected SQLSTATE returned from embedded SQL
... do you use commit and if, what isolation level do you use forthis programm?.
If the table is journaled, using the journal to analyse the problem would be the best option. The effort would be minimal to direct theentries to an outfile, restructure the entdta (there is an utility ANZJRN at my – sorry german – open source site) and using interactive SQL to see what happened.
Dieter
--
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:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
