Re: TempTable not found error - SQL0204

Is this what you are doing?
<clip from info center>
You can create a temporary table for use with your current session. To create a temporary table, use the DECLARE GLOBAL TEMPORARY TABLE statement.
This temporary table does not appear in the system catalog and cannot be shared by other sessions. When you end your session, the rows of the table are deleted and the table is dropped...
This table is created in QTEMP....</clip>

So if you are starting sessions at sbs QINTER startup -
they will get a new QTEMP for the new jobs.
You would have to create the temp table again (if I understand what you are doing in the application..)

Jim Franz




----- Original Message ----- From: "Dave" <daveML@xxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Sunday, August 09, 2009 11:24 AM
Subject: TempTable not found error - SQL0204

Message . . . . : TEMPTABLE in *LIBL type *FILE not found.

This is the second time I have seen this error pop up on a SQL cursor in one of our service programs. The SQL uses a TempTable structure to create a small temporary table that is referenced in the main SQL body. The error is thrown when the open is called for the cursor.

It runs perfectly hundreds of times per day, and has for many months. But two times now, on weekends when no one is even around, it has failed. The common factor seems to be that these sessions are auto-starting as QINTER is restarted after our backup completes.

Obviously we can trap for this error and handle it, but it seems odd.

How can a run-time temp table not exist?

Dave
--
This is the RPG programming on the IBM i / System i (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.