alter table in a stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tojigneshshah@gmail.com - 05 Jun 2006 15:55 GMT

Hi,

In a stored procedure,

If i use "alter table <tablename> activate not logged intially with
empty table", i get SQL104n error.

If i use "execute immediate alter table <tablename> activate not logged
initially with empty table" then i get SQL0107n (saying max.length is
64 characters)

Please advice.

Regards,
Jignesh

Reply to this Message

Serge Rielau - 05 Jun 2006 16:38 GMT

> Hi,
>
[quoted text clipped - 6 lines]
> initially with empty table" then i get SQL0107n (saying max.length is
> 64 characters)

DECLARE txt VARCHAR(32000);
SET txt = 'ALTER TABLE .....';
EXECUTE IMMEDIATE txt;

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

tojigneshshah@gmail.com - 05 Jun 2006 16:58 GMT

thanks

> > Hi,
> >
[quoted text clipped - 20 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message