How to start fetching the rows from the abended row in DB2?

thamodharan · Member Joined: 21 Oct 2008 Posts: 14 Location: chennai

Hi All,

I have a program which is fetching 2000 rows from a table. I encountered an abend after fetching 1000 rows and written into the output file. So, I need to start fetching the rows from 1000, instead of starting from Row1.

Can anyone suggest me how to start fetching the records like I mentioned above?

Thanks.

Natarajan · Moderator Joined: 10 Oct 2008 Posts: 427 Location: chennai

You may need to modify the code for this.
You better write a logic to skip first 1000 records and start writing from 1001th
record into file. You can implement this small logic after fetch.

But one thing remember, you need to make sure, when we run the program again
cursor should get the rows in the same order of its first run. otherwise we may end up missing some records.

DB2 provides the FETCH FIRST clause to fetch first few records. I am not sure
whethere we have any thing like FETCH FROM <ROWn> to <ROWnnn>.
_________________
Natarajan
Chennai

anv2010 · Posted: Fri Feb 05, 2010 12:17 am Post subject:

You'd have to implement basic RESTART into your application, e.g. add WHERE clause to your DECLARE cursor statement. Then, make sure to save (INSERT) the corresponding working-storage fields into a DB2 table, etc...

Please note, that there's also an issue of repositioning your "output file."

Alternatively, you can opt-in for an external to your application checkpoint/RESTART product like Smart/RESTART: http://www.relarc.com/smartrestart/

Topics		Replies	Author	Views	Last Post
Related topics
	Announcement: DB2 QUICK START - E-Book Release - only for $2	6	Krishna	3910	Tue May 19, 2009 11:22 am Vamsi99
	IMS start up	5	madhureddygs	1416	Sun Jan 10, 2010 2:37 pm Anuj Dhawan
	When you do a START, what will the value of EIBCALEN?	1	Krishna	377	Sun Jul 19, 2009 8:57 pm Krishna
	I have done a START BROWSE on a VSAM dataset.	1	Krishna	319	Sun Jul 19, 2009 8:54 pm Krishna
	START with Alt Index Key	1	jay	1036	Thu Jul 03, 2008 8:20 pm laxmi_maha2000

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