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.
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.