IBM MAINFRAME HELP & SUPPORT FORUMS

shriya reddy · Joined: 05 Jun 2004 Posts: 45

Hi Friends,

I heard we can the length of column using ALTER Stmt in new versions of DB2. please give how we code to change length of the column.

Regards,
Shriya Reddy.

shriya reddy · Joined: 05 Jun 2004 Posts: 45

Hi Friends,

Anybody give me the answer.

Bye
shriya.

ovreddy · Posted: Thu Dec 09, 2004 2:28 pm Post subject: Here is your answer...

Hi Shriya,

The following syantax will work. It is available only with DB2 8.2 and higher ok try it out.

ALTER TABLE CUSTOMER COLUMN ADDRESS SET DATA TYPE CHAR (35)

shriya reddy · Joined: 05 Jun 2004 Posts: 45

Hi OV Reddy

thanks for reply

Shriya

khamarutheen · Joined: 23 Aug 2005 Posts: 678 Location: chennai

hi frnd,
using alter table u can only increase the present datatype length.. u cannot decrease it. note that carefully.

Eg:
ALTER TABLE CUSTOMER COLUMN ADDRESS SET DATA TYPE CHAR (35)

can be made as
ALTER TABLE CUSTOMER COLUMN ADDRESS SET DATA TYPE CHAR (55)

but cannot
ALTER TABLE CUSTOMER COLUMN ADDRESS SET DATA TYPE CHAR (15)

Kavitha Palani · Joined: 16 Nov 2005 Posts: 9

ALTER TABLE <TABLE NAME> COLUMN<COLUMN NAME> SET <DATA TYPE > (35)

sri.mainframes · Joined: 16 Feb 2006 Posts: 29 Location: MUMBAI

Hi Shreya

try this one

ALTER TABLE <tablename>
ALTER COLUMN <columnname>
SET DATATYPE <newdatatype> ;

this will work

regards
PRINCE