Re: AW: TempTable not found error - SQL0204

["Dave" <daveML@xxxxxxxxxxxx>]

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