Inserting a record from file into db table



IBM's flagship relational database management system

Inserting a record from file into db table

Postby mahindra_b » Wed Feb 17, 2016 11:28 pm

Hi all,


I was asked this question in an interview
You need to insert records from a flat file containing 1000 records...
suppose after inserting 400 records program abended due to some data problems...,
After solving the problem and when you run the code, insertion should start from 401th record


please help me.
mahindra_b
 
Posts: 1
Joined: Tue Feb 16, 2016 10:43 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Inserting a record from file into db table

 

Re: Inserting a record from file into db table

Postby NicC » Thu Feb 18, 2016 3:00 am

commit after every record and keep a count of the number of records read and/or committed. restart by skipping the commit count of records.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2663
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 100 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post