?When u r trying to retrieve some rows from DB2 table into ur application , say using a cursor then during which part of the cycle of the cursor does the task actually takes place ?(open, fetch, close, or after close , WHEN ?)i.e, when u practically get the data in the form of rows into ur application & how ?
?Now when u have retrived the data how will u put in a flat file.
?Will u open a new file for it or in the same file u read and write, how u achieve it ? Pls explain me theoretically and also with an example of code.
?How will u confirm whether all the required records have been copied properly,
And how can we achieve the whole above process vice-versa ,i.e, from a flat file to DB2.