RE: SQL7911 - ODP reused

I solved the joblog problem by changing the submit job to not log
severity zero errors.

There are not 10,000 SQL statements but multiple calls execute the
statements.   Driver program reads an employee record, does its updates
and then calls subsequent programs to update other files.  

Bonnie Lokenvitz
320.679.2599
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of HauserSSS
Sent: Thursday, July 06, 2006 11:38 AM
To: RPG programming on the AS400 / iSeries
Subject: AW: SQL7911 - ODP reused

Hi,

just a question?
Did you start debug?

If so all SQL-Messages get listed in the joblog.
If you end your debug the SQL-Messages should not be listed any more.

... but 10,000 of pages the Reuse ODP?! That means you execute 10,000 *
x
SQL-Statements?!

Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les Brown)

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Bonnie Lokenvitz
Gesendet: Donnerstag, 6. Juli 2006 16:09
An: RPG400-L@xxxxxxxxxxxx
Betreff: SQL7911 - ODP reused


Previously SQLRPGLE and Maximum number of Files.

I had no response to why my compile failed when adding a 94th file for
update so I have since divided the files amongst 1 driver and 2 called
programs.

Now I am getting 10,000 plus pages of job log with the message SQL7911
(An ODP that was previously created has been reused.).
IBM manuals indicate that is not a bad thing (I do not set on LR in the
called programs until driver is ready to end).

Is there any way to prevent all the SQL7911 messages in the joblog?

Thank you,
Bonnie Lokenvitz
  Technology Consulting Inc
  320.679.2599


--
This is the RPG programming on the AS400 / 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.