Want to change length from 3 fields to 4 fields using DB2

santhunaveen · New User Joined: 22 Sep 2006 Posts: 33

Hi,

I have a field heving length of 3 characters, now i want to change this as 4 characters using DB2.

Example in table field1 is having value '384', now I want to change this as '0384' in table using DB2 ....

Can i use LIKE for this purpose....

Please help me in this regard.....

vini_srcna · Posted: Wed Mar 07, 2007 5:37 pm

Are you taking about the data in the field1..?

What is the datatype of field1. Is that CHAR(03)...? Do you need to change that to CHAR(04) ...?

If you want to change it from CHAR(03) to CHAR(04) then get in touch with DBA and make sure all the application programs accessing that table/column are changed accordingly.The DDL of that table needs to be altered. If you are talking about just the data then it could be done with simple SQL query.

santhunaveen · New User Joined: 22 Sep 2006 Posts: 33

Hi,

I want to change data only.......thru sql query how can we do this......can u give me some suedo code for this..............

vini_srcna · Posted: Wed Mar 07, 2007 7:30 pm

UPDATE tablename SET colname = '0'||colname ;

vini_srcna · Posted: Wed Mar 07, 2007 7:32 pm

That will update all the records in the table. Make sure you are correct before you execute the query.

santhunaveen · New User Joined: 22 Sep 2006 Posts: 33

Hi,

Thanks.....it's working fine.......