Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Length of the Table column to be increased

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Rahul_kumar
Warnings : 2

New User


Joined: 24 Jun 2006
Posts: 50

PostPosted: Tue Apr 10, 2012 7:14 am    Post subject: Length of the Table column to be increased
Reply with quote

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
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Apr 10, 2012 9:17 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Rahul_kumar
Warnings : 2

New User


Joined: 24 Jun 2006
Posts: 50

PostPosted: Tue Apr 10, 2012 1:42 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Tue Apr 10, 2012 1:58 pm    Post subject: Reply to: Length of the Table column to be increased
Reply with quote

With all due respect to Sushanth, your DBA(s) are the best people at whom to direct specific questions about your set-up.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
No new posts Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us