Alter Column

[Kimi]

Hi,

I'm trying to change a column on a DB2 table so that it has a default value
but I cannot get it to work. Does anyone have any experience in this area.

I'm trying with this statement:

Alter Table x
Alter column y default 0;

I also tried with this:

Alter Table x
Alter Column y Set Data Type SmallInt With Default 0;

And this:

Alter Table x
Alter Column y Set Default 0;

I simply cannot make it work ;o(

Thanks in advance

Kimi

[Serge Rielau]

Kimi wrote:

Hi,

I'm trying to change a column on a DB2 table so that it has a default value
but I cannot get it to work. Does anyone have any experience in this area.

I'm trying with this statement:

Alter Table x
Alter column y default 0;

I also tried with this:

Alter Table x
Alter Column y Set Data Type SmallInt With Default 0;

And this:

Alter Table x
Alter Column y Set Default 0;

I simply cannot make it work ;o(

Which versiuon are you on?
DB2 V8.2 for LUW introduced altering of the default.
The syntax is described in the online books and in the latest (FP7)
local doc download.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Kimi]

It's DB2 V8.1 on z/OS ... as for the guides, I have a hard time
understanding what they're trying to describe ...

Thanks

Kimi

"Serge Rielau" <sr*****@ca.ibm.com> skrev i en meddelelse
news:49************@individual.net...

Kimi wrote:

Hi,

I'm trying to change a column on a DB2 table so that it has a default
value but I cannot get it to work. Does anyone have any experience in
this area.

I'm trying with this statement:

Alter Table x
Alter column y default 0;

I also tried with this:

Alter Table x
Alter Column y Set Data Type SmallInt With Default 0;

And this:

Alter Table x
Alter Column y Set Default 0;

I simply cannot make it work ;o(

Which versiuon are you on?
DB2 V8.2 for LUW introduced altering of the default.
The syntax is described in the online books and in the latest (FP7) local
doc download.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Serge Rielau]

Kimi wrote:

It's DB2 V8.1 on z/OS ... as for the guides, I have a hard time
understanding what they're trying to describe ...

Well, the syntax would be:
ALTER TABLE <tablename> ALTER COLUMN <columnname>
and then syntax to set/add or alter the default, but all you can do is
SET GENERATED [ALWAYS|DEFAULT].
Seems like you're out of luck w.r.t. to the straight approach.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab