Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
This topic is locked: you cannot edit posts or make replies. Selecting two copybooks of different ... Vignesh Sid COBOL Programming 8 Tue Sep 05, 2017 7:28 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us