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
 

 

How to modify a column attribute like Length,PIC in DB2?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
softwareengineer

New User


Joined: 24 Aug 2005
Posts: 24
Location: Hyderabad

PostPosted: Thu Jul 12, 2007 2:52 pm    Post subject: How to modify a column attribute like Length,PIC in DB2?
Reply with quote

How to modify a column attribute like Length,PIC in DB2?

My question is quite big. If I want to change a field/column name say NAME of length '3' to '5'. How can I modify my table with out effecting existing info?

once after making field lenght changes in my DB2 table, what else needs to be done in my COBOL-DB2 program to accomodate tht field modification and what abt the Precompile , Bind process??

Thanks in advance.
Back to top
View user's profile Send private message

muthuvel

Active User


Joined: 29 Nov 2005
Posts: 217
Location: Chennai

PostPosted: Thu Jul 12, 2007 3:14 pm    Post subject: Re: How to modify a column attribute like Length,PIC in DB2?
Reply with quote

I think a developer will not be given permission for changing the column alteration in DB2.You have to get in touch with your DBA team who will be doing the changes as per the requirement.

In case of COBOL+DB2 program,you must find the programs in which the modified table is used and in specific,the affected column is used.All the programs which use the modified column in any of the SQL type(select,insert,update or delete) needs a recompilation.The program logic also needs a double check since the field size is increased.

Hope this helps.
Back to top
View user's profile Send private message
softwareengineer

New User


Joined: 24 Aug 2005
Posts: 24
Location: Hyderabad

PostPosted: Thu Jul 12, 2007 3:44 pm    Post subject: Re: How to modify a column attribute like Length,PIC in DB2?
Reply with quote

Yes. As a developer, we are not given access to do so. This question was asked in a interview. I just want to how we can do it in test region. please provide the answer from DBA point of view.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts Length of Tape file Mohan Kothakota JCL & VSAM 9 Thu Apr 20, 2017 10:24 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Writing on to GSAM variable length rohanthengal JCL & VSAM 6 Fri Mar 03, 2017 7:46 pm


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