Length of the Table column to be increased

Rahul_kumar · New User Joined: 24 Jun 2006 Posts: 50

Hi,

I have a requirement to increase the length of the text column of the table;defined as VARCHAR;from 100 to 5000 char.The problem is that the column is in the middle of the table.It's an online system with Java as front-end and uses WSDL files to transfer data to Cobol programs.

I searched the table name in the cobol library and analysed all the programs using this table which will be re-compiled.Also,whereever this field is being moved to another WS field in the program;the length of that particular field also needs to be changed.

My doubt is that since the column is in the middle of the table;do I need to take care of anything else.(or rest is upto the DBA's to modify the table structure and do the testing including the back-out testing).

Changes would also be there in the Java front end screens,and the WSDL files( to increase the lenght of the text field).I don't have much idea about WSDL but have been told that the copybooks will be generated automatically once the WSDL is modified and promoted through endevor.

How will the XSD(Schema definition) be impacted.I have'nt modified it anytime thereby no idea how to do the same.

Thanks in Advance!
Rahul

sushanth bobby · Posted: Tue Apr 10, 2012 9:17 am

Rahul,

DBA should take care of increasing the length of the column. If backout is required, DBA should revert back the length of the column to 100. (just check with your DBA, what are the steps he will be doing)

Since XSD schema is there, you can take a look at it for this column, how it is defined there, just check how the column is specified there, anything related to length is there.

Thanks,
Sushanth

Rahul_kumar · New User Joined: 24 Jun 2006 Posts: 50

Hi Sushant,

Thanks for the reply.So,will the DBA has to drop the table and will require an outage to be taken since the table is used 24 X 7.

Bill Woodger · Posted: Tue Apr 10, 2012 1:58 pm

With all due respect to Sushanth, your DBA(s) are the best people at whom to direct specific questions about your set-up.