Page 1 of 1

Inserting a record from file into db table

PostPosted: Wed Feb 17, 2016 11:28 pm
by mahindra_b
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.

Re: Inserting a record from file into db table

PostPosted: Thu Feb 18, 2016 3:00 am
by NicC
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.