reading a row from table and writing a record into file



IBM's flagship relational database management system

reading a row from table and writing a record into file

Postby pradeepgowda » Fri Apr 09, 2010 12:53 pm

suppose we are reading a db2 table and writing into a file. the table has 1 million records. if program abends in between will the program has to be started from the beginning. if we want to restart from the last accessed row from the table without having impact to the allready written records into file. how to proceed.how the output file needs to be handled
pradeepgowda
 
Posts: 40
Joined: Mon Jan 04, 2010 4:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: reading a row from table and writing a record into file

 

Re: reading a row from table and writing a record into file

Postby dick scherrer » Sat Apr 10, 2010 12:30 am

Hello,

Suggest you plan on restarting from the beginning. . .

If your environment does not already have restart/recovery mechanics in place, you do not want to try to do this for one program/process.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post