some questions in db2.

elayarajack · New User Joined: 15 Feb 2004 Posts: 8

hi,

plse answer the following questions

1.diff. between Repeatable Read(RR) and Cursor Steablity(CS)

2.what is TWO PHASE COMMIT.

3. hoe to see the alternative rows of a table(ie 1,3,5,7,etc).

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 257 Location: USA

Hello elayarajack,

1) Diff. between Repeatable Read(RR) and Cursor Steablity(CS)

2) TWO PHASE COMMIT
This occurs when a programmer Issues a Exec CICS Syncpoint command. This is called two phase because CICS will first commit changes to the resources under its control like VSAM files and the DB2 changes are committed. Usually CICS signals DB2 to complete the next phase and release all the locks.

3) Display alternate rows of a table

Hope this helps,

Regards
Mayuresh Tendulkar

Ananya · New User Joined: 26 Feb 2004 Posts: 21 Location: Chennai

Dear ,

Here is the query. try working out.

FOR ODD NUMBERS (1,3,5,7,....)

SELECT E, EMP.* FROM
(SELECT ROWNUM E, EMP.* FROM EMP) EMP
WHERE MOD(E,2)=1

FOR EVEN NUMBERS(2,4,6,8,.....)

SELECT E, EMP.* FROM
(SELECT ROWNUM E, EMP.* FROM EMP) EMP
WHERE MOD(E,2)=0

HOPE I HAVE ANSWERED UR QUERY 8)