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

Increase the length of a column through ALTER command
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
manojraja

New User


Joined: 10 Aug 2007
Posts: 7
Location: india
PostPosted: Tue Aug 14, 2007 3:05 pm
 Reply with quote
hi ,

can we drecrease or increase the length of a column through ALTER command in db2????

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

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
PostPosted: Tue Aug 14, 2007 5:35 pm
 Reply with quote
SQLCODE -190 You cannot change a column's data type and length (other than increasing the length of a VARCHAR column as of DB2 V6).
Back to top
View user's profile Send private message
manojraja

New User


Joined: 10 Aug 2007
Posts: 7
Location: india
PostPosted: Thu Aug 16, 2007 10:46 am
 Reply with quote
Thanks a lot.....
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 Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Store the data for fixed length COBOL Programming 1
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts RACF - Rebuild SETROPTS command which... All Other Mainframe Topics 3
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us