Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
-526 while updating the temporary table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
Ragav86

New User


Joined: 27 Jan 2010
Posts: 7
Location: chennai

PostPosted: Thu Feb 04, 2010 10:46 pm    Post subject: -526 while updating the temporary table
Reply with quote

Hi i am getting -526 sqlcode while updating the temporary table in my stored procedure
Can any one help me to resolve this problem ?

Is this related to authorization on the table?
Back to top
View user's profile Send private message
References
dick scherrer

Global Moderator


Joined: 23 Nov 2006
Posts: 13597
Location: 221 B Baker St

PostPosted: Thu Feb 04, 2010 11:16 pm    Post subject:
Reply with quote

Hello,

Did you look up the meaning of a -526? If not, do so now.

The description of the error mentions nothing about authorization. . .

If you read something in the error description that is not clear, post your doubt and someone may be able to clarify.
Back to top
View user's profile Send private message
Akatsukami

New User


Joined: 03 Oct 2009
Posts: 81
Location: Bloomington, IL

PostPosted: Thu Feb 04, 2010 11:19 pm    Post subject:
Reply with quote

No, it is because you are attempting an operation that is not allowed on temporary tables, as the fine manual would have told you.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1