ROWID data type in DB2 9.7

Divya_kamath · #1 (**permalink**) 10-05-11, 09:17

Can anybody give me the hint why ROWID data type is not being recognized in db2 9.7

tonkuma · #2 (**permalink**) 10-05-11, 09:29

Because, there is no such data type in DB2.

DB2 Version 9.7 for Linux, UNIX, and Windows
Data types
http://publib.boulder.ibm.com/infoce.../r0008483.html

Divya_kamath · #3 (**permalink**) 10-05-11, 09:39

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..

Marcus_A · #4 (**permalink**) 10-05-11, 09:40

It is supported in DB2 for z/OS. Make sure you are using the correct documentation because DB2 for z/OS is a different product than DB2 LUW.

Marcus_A · #5 (**permalink**) 10-05-11, 09:43

Quote:

Originally Posted by Divya_kamath

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).

tonkuma · #6 (**permalink**) 10-05-11, 09:54

Thank you!
Marcus.

How I studied on a subject(e.g. DB2 SQL), still there are more things to learn.

Divya_kamath · #7 (**permalink**) 10-05-11, 10:24

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