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 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
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 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


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