× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



The message definitely said TempTable, although I suspected that it might be QAOKP03A that it could not find. There was no indication of that in the job log, and the backup had completed before the error so I do not think it was a lock.

And the error occurred on the open of this specific cursor.

I will add some code to dump the library list and program if it happens again. Maybe that will shed some light on the issue.

Thanks for the response,
David

--------------------------------------------------
From: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
Sent: Sunday, August 09, 2009 9:09 PM
To: "'RPG programming on the IBM i / System i'" <rpg400-l@xxxxxxxxxxxx>
Subject: AW: TempTable not found error - SQL0204

Hi,

TempTable is not an existing table it is nothing else than a temporary view
which is only available for the CurAuto cursor, i.e. it even cannot be used
by other SQL statements within his source.

Is it really TempTable which is not found or is it TDTasks or TDActions or
QAOKP03A?

IMHO when opening the cursor the library list is not yet correctly or
completely set!

Mit freundlichen Grüßen / Best regards

Birgitta Hauser




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.