Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Changing Field Length

Former Member

‎2007 Nov 06 6:04 AM

0 Likes
2,953

I have one ztable with a x field of 20 length. This table was populated by one extractor which may some times has a length 30 for that x field. So the text was saved only upto 20 length.Ztable contains lot of production datas and this table was used by lot of other programs. I want to change the field length to 30. How can i do?

I have one ztable with a x field of 20 length. This table was populated by one extractor which may some times has a length 30 for that x field. So the text was saved only upto 20 length.Ztable contains lot of production datas and this table was used by lot of other programs. I want to change the field length to 30. How can i do?

Reply
5 REPLIES 5
Read only

Former Member

‎2007 Nov 06 6:06 AM

0 Likes
2,196

Hi,

You can change the field length to 30. Recreate the table maintainance and activate and adjust DB using SE14.

Regards,

Atish

Read only

Former Member

‎2007 Nov 06 6:06 AM

0 Likes
2,196

No problem, You can go ahead and change the field lenght. If the table is having table maintenance you need to create new table maintenance for it.

But it won't affect the existing data.

PRa

Read only

Former Member

‎2007 Nov 06 6:14 AM

0 Likes
2,196

Hi

In Se11 change the lenghht of ur field to the required length .

After that dont forget to Activate and Adjust Table in Se14..

If TMG available , you need to regenerate it ..

Thanks.

Praveen

Read only

Former Member

‎2007 Nov 06 6:21 AM

0 Likes
2,196

Hi MURUGESH,

First u change ur field's domain length. Then thru SE14 data base utility u have to adjust the database & activate the same. Or from SE11 open the ZTable, from menu bar Utilities===> Database utility u can adjust the database.

Reward pts if it is helpfull.

Regards

srimanta

Read only

Former Member

‎2007 Nov 06 7:34 AM

0 Likes
2,196

Hi,

Change the length of the field to desired. Save and Activate the table.

Once activated go to SE14, give the table name and select the radio button "Adjust database".

Thanks,

Sri.