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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Migrating MYSQL to DB2
- Thread starter rmicheald
- Start date
Depending on how large this field is you might use a CLOB or just a variable Char field. Thwe CLOB is a character Large object and can be stored on a seperate table with a pointer to it so DB2 does not need to read that field for joins and other queries not requiring this field.<br>
Try the IBM web site -- <A HREF=" TARGET="_new"> and looka t the DB2 library. (I don't have the exact address handy) an this should give you a better idea as to which data type to use.<br>
Try the IBM web site -- <A HREF=" TARGET="_new"> and looka t the DB2 library. (I don't have the exact address handy) an this should give you a better idea as to which data type to use.<br>
- Status
Similar threads
- Locked
- Question