Hi,

I want to drop an expression from the generated table column in DB2 (AIX) v8.1. I am getting the following error:

56098(-727)[IBM][CLI Driver][DB2/AIX64] SQL0727N An error occurred during implicit system action type "3". Information returned for the error includes SQLCODE "-101", SQLSTATE "54001" and message tokens "". SQLSTATE=56098

>> Type 3 in documentation implies that there is one or more view which needs to be regenerated.

Can somebody tell me how to regenerate the view on DB2/AIX?

<<
Additionally I googled and found the following code
ALTER VIEW view REGENERATE;
But it did not work on DB2/AIX as it strangely works (?) on z/OS2 only
>>

Thanks

What's important here is SQLCODE "-101": "Statement too long or too complex". Try increasing the value of the STMTHEAP database configuration parameter.

Hi,

I could not find better way of doing it. After spending hours I came to the conclusion that dropping and recreating the views is the only feasible solurion. So I dropped the views, which were causing problems, then I dropped the expression of generated column and then recreated views. And VOILA it worked just fine

Thanks everyone for your suggestions.

- AJ