how to reteieve the cursor randomly??

bnirmalraj · Member Joined: 20 Sep 2006 Posts: 5

hi all
how to reteieve the cursor randomly??

Kalicharan · Moderator Joined: 08 Feb 2006 Posts: 31

Hi,

If your requirement is random access to a resultant table
you can achieve by scrollable cursor.

This mode enables random access to rows in a result set, but currently is supported only by IBM DB2 Universal Database.

Scrollable cursors allow random access to a result table. Applications can use a powerful set of SQL to fetch data using a cursor in random order. Scrollable cursors are especially useful for screen-based applications. You can specify that the data in the result table is to remain static, or you can perform the data updates dynamically.

Thanks
Kalicharan

Topics		Replies	Author	Views	Last Post
Related topics
	with Hold cursor in a stored procedure	1	venkatreddy.com	3633	Mon Nov 26, 2007 11:23 pm DavidatK
	What is the diff between declaring a cursor in WSS or PD?	4	mkk157	3006	Tue Apr 03, 2007 8:35 pm dbzTHEdinosauer
	S0C6 Abend while Opening a DB2 Cursor in a DB2-PLI Proram	0	karthik_desabhatla	2160	Tue Dec 26, 2006 9:03 pm karthik_desabhatla
	S0C6 Abend while Opening a Cursor in a DB2-PLI Proram	0	karthik_desabhatla	1682	Tue Dec 26, 2006 9:01 pm karthik_desabhatla
	S0C6 Abend while Opening a Cursor in a DB2-PLI Proram - Sugg	0	karthik_desabhatla	3377	Tue Dec 26, 2006 8:58 pm karthik_desabhatla

	mainframegurukul.com Forum Index -> DB2 SQL - DB2 PROGRAMMING	All times are GMT + 5 Hours
Page 1 of 1