ROWID

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
User avatar
ibmlearner
Member
Posts: 13
Joined: Sat Dec 02, 2006 5:57 pm

ROWID

Post by ibmlearner » Thu Mar 08, 2007 8:18 pm

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.
Thanks & Regards
-------------------------
Learner

Veera
Moderator
Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Sat Mar 10, 2007 12:32 am

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

academyindia4

Topic deleted by Admin

Post by academyindia4 » Fri Jan 15, 2016 9:17 pm

<< Content deleted By Admin >>

Post Reply

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



Other References
Mainframe Tools and others