If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
Thanks for your reply .If there is no ROWID data type then how can we store data for blob and clob columns? Or can you tell me how can we use blob and columns in db2 for large objects..
You just add those columns to your table. It is usually a good idea to store such columns in a different tablespace (see CREATE TABLE with LONG IN option for LOB data), and if you have 9.7 you may want to use the INLINE option when you define the LOB column (particularly if the average length of the data will fit on the page you have selected for the table).
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Once again my thanks for your responses. I referred some redbooks from IBM to learn LOBs. Can anybody please suggest me any links or redbooks for LOBs in DB2 for LUW.I am currently using DB2 9.7 express c edition. Your information will be valuable for a fresher like me. Thanks in advance