IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How can we update the field size in DB2?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Husna

New User


Joined: 02 Jun 2006
Posts: 49

PostPosted: Wed Sep 27, 2006 9:25 am
Reply with quote

Hi all,

In DB2 we need to update the field size from 18 to 26? How can we do the same? What will happen (in subprograms) while doing the same? Where we need to increase the field size (In copybook or...)? Please give me brief description?
Back to top
View user's profile Send private message
cj10

New User


Joined: 18 Sep 2006
Posts: 9

PostPosted: Wed Sep 27, 2006 11:34 am
Reply with quote

By updating field size, do you mean increasing the length of a column size from 18 to 26 chars?

Assuming the above, in this case, the DBA will increase the column length using ALTER TABLE command. Generally, we do not have such privileges.

Once we have the modified column length in the table, we can re-generate the DCLGEN to have modified host variable declarations. The same will be used in the program & sub-programs. If we have used any working storage variables for any of the modified columns for some processing, then those variables have to be modified to reflect the column length changes.

Corrections Welcome !!!!!!!!!!
==========================================================================
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts How to move the first field of each r... DFSORT/ICETOOL 5
Search our Forums:

Back to Top