Iam workin on a CICS+COBOL+DB2 program...
Iam designing an online examination system..
So my requirement is i have to fetch the questions from a table and display in a map and once user gives the answer at tat moments it has to be evaluated and computed at the background and then the next question must be displayed to him waiting for his option..
In this process iam successful in first instant but the program doesn fetch and display the second ques though i have used cursors..iam looping this fetching and computing para until sql code=100 in a perform..Require your inputs and help on how it could be done..
Thanks in Advance..
Thanks alot for all ya quick response..i was successful in displayin the questions one by one from the table by fetching..i have 4 modules of ques papers like J001,C001,D001,I001 each having 5 ques each..the user will choose one of the modules to write the test..this info is stored in a registration table..i have to fetch this module for which the user has registered from the registration table and then correspondingly i have to fetch the questions from the question table..the challenge iam facing is tat the cursor fetches the rows one aftr the other and displays all q.papers..so iam stuck as to how i could initially point ma cursor to the row in q.paper table which has the module for which user has registered and from there i have to loop it 5 times..
In simple words i have to initially point ma cursor dynamically to tat row of the table which has been seleceted by the user and from there i have to fetch 5 ques..I know tat i could achieve this by using scrollable cursors but the prob is i have NO ACCESS FOR THAT..so guys plz suggest me as to wat r the possible ways..
Thank u guys again for all ya inputs..