The database query would fetch more than 1000 records as resultset.
Now, I have to loop through each record and extract values from records and each record would be considered as a client request. Each client request is formed as a XML and written into a file. Limitation is each file should contain ONLY 200 requests (records). How should I dynamically create the XML objects for every 20 records and put them in a file.
I.e. The 1000 records should result in 5 files with 200 records (XML requests) each. Could somebody help me in doing this?