HI ALL..
WHAT IS ACTUALLY ROWID.
ITS FOR INDENTFYING THE ROW,MEANS THEN
WHAT IS THE USE OF INDEXES ???????
IS (UNIQUE) INDEX USES ROWID???
TIA.
ROWID
Moderators: Kalicharan, Moderator Group
- ibmlearner
- Member
- Posts: 13
- Joined: Sat Dec 02, 2006 5:57 pm
ROWID
Thanks & Regards
-------------------------
Learner
-------------------------
Learner
ROWID is a data type to store a unique Row IDentifier assigned by DB2.
Indexes are used to identify a unique tuple.( I mean entire columns of the record)
What do you mean by INDENTFYING THE ROW ??
Identifying by just the numbering of it ???
Or
Identifying by some value you provide to Table ??
First thing is possible by ROWID but not the second.
ROWID cant be used to identify the rows for a specific criteria , i mean its just the numbering for the rows which DB2 subsytem internally stores as a hidden column i guess
Normally we will provide some value in the where clause to fetch data
from DB2 in that case Indexes are in effect.
Select sal
From Emp
where sal = 100$ -> Here fetcing the data using a specif criteria like
where sal should be 100 cant be obtained by ROWID,
but your other query where you just want to fetch
the records from DB2 without any refernce to the
where clause specific condition like records
from 200 to 300 or so the ROWID can be used.
Thanks
Veera
Indexes are used to identify a unique tuple.( I mean entire columns of the record)
What do you mean by INDENTFYING THE ROW ??
Identifying by just the numbering of it ???
Or
Identifying by some value you provide to Table ??
First thing is possible by ROWID but not the second.
ROWID cant be used to identify the rows for a specific criteria , i mean its just the numbering for the rows which DB2 subsytem internally stores as a hidden column i guess
Normally we will provide some value in the where clause to fetch data
from DB2 in that case Indexes are in effect.
Select sal
From Emp
where sal = 100$ -> Here fetcing the data using a specif criteria like
where sal should be 100 cant be obtained by ROWID,
but your other query where you just want to fetch
the records from DB2 without any refernce to the
where clause specific condition like records
from 200 to 300 or so the ROWID can be used.
Thanks
Veera
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page