Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing Datatype

Status
Not open for further replies.
gotluru

gotluru

Programmer
Joined
Oct 16, 2000
Messages
10
Location
US
Hi,

Can I change Datatype Varchar2 to Clob by using Alter Table Command?

Thanks in Advance..
Prasad
 
Sort by date Sort by votes
Hi there
Yes you can alter the data type using alter table but i'm not sure whether DB2 can convert varchar2 to Clobs ?

Hope this helps!

ALTER TABLE table-name ALTER COLUMN column-name SET DATA TYPE type size.

 
Upvote 0 Downvote
IBM documentation states you can CAST between VarChar(2) and CLOB.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Pack10
  • Locked
  • Question Question
IBM mainframe password changing.....
Replies
8
Views
446
Pack10
Pack10
fletchsod
  • Locked
  • Question Question
SQL Error - BigInt datatype
Replies
1
Views
215
fletchsod
fletchsod
Powernic
  • Locked
  • Question Question
Changing buffer pool size
Replies
0
Views
149
Powernic
Powernic
sbhav
  • Locked
  • Question Question
DB2 datatypes
Replies
1
Views
202
blom0344
blom0344
nostricon
  • Locked
  • Question Question
Changing isolation level on a DB2 java stored procedure
Replies
0
Views
160
nostricon
nostricon

Part and Inventory Search

Sponsor

Back
Top