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.

 
Go Back  dBforums > Database Server Software > DB2 > ROWID data type in DB2 9.7

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2011
Posts: 29
ROWID data type in DB2 9.7

Can anybody give me the hint why ROWID data type is not being recognized in db2 9.7
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Feb 2008
Location: Japan
Posts: 3,386
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

Last edited by tonkuma; 10-05-11 at 09:33. Reason: Add reference.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2011
Posts: 29
About ROWID

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..
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,719
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.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,719
Quote:
Originally Posted by Divya_kamath View Post
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
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Feb 2008
Location: Japan
Posts: 3,386
Thank you!
Marcus.

How I studied on a subject(e.g. DB2 SQL), still there are more things to learn.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Jan 2011
Posts: 29
About ROWID

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
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,719
These are not Redbooks (which are no longer red anyway), but here are the PDF manuals:
https://www-304.ibm.com/support/docv...id=swg27015148

Here is the online InfoCenter:
IBM DB2 9.7 for Linux, UNIX and Windows Information Center
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Jan 2011
Posts: 29
About ROWID

Thank you so much Marcus_A .. I will check it out.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On