IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Inserting a record from file into db table



IBM's flagship relational database management system
Post a reply

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
Top

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: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks
cron