alter table in a stored procedure
This is a discussion on alter table in a stored procedure within the DB2 forums, part of the Database Server Software category; --> Hi, In a stored procedure, If i use "alter table <tablename> activate not logged intially with empty table", i ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:15 AM
| ||||
| ||||
 alter table in a stored procedure 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      |
|
02-27-2008, 08:15 AM
| |||
| |||
| Re: alter table in a stored procedure tojigneshshah@gmail.com wrote: > 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) DECLARE txt VARCHAR(32000); SET txt = 'ALTER TABLE .....'; EXECUTE IMMEDIATE txt; Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/ |
|
02-27-2008, 08:15 AM
| ||||
| ||||
| Re: alter table in a stored procedure thanks Serge Rielau wrote: > tojigneshshah@gmail.com wrote: > > 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) > DECLARE txt VARCHAR(32000); > SET txt = 'ALTER TABLE .....'; > EXECUTE IMMEDIATE txt; > > Cheers > Serge > > -- > Serge Rielau > DB2 Solutions Development > IBM Toronto Lab > > IOD Conference > http://www.ibm.com/software/data/ond...ness/conf2006/ |
Linear Mode
