MVSFORUMS.com

[omswarup]

i am stuck with a weird problem in eastrieve. Could you please help me out in this.

I have a eaasytrieve program which uses a input file to get a particular value like policy number and fetches the data from the table to get a field from it and writes a ouput which is same as that of the input but the field obtained from the table is also written in the record.

I am using cursors to do it, but the problem is for every read i need to open the cursor, fetch the record and close it , if i open the cursor using the start proc and close the cursor using the finish proc it doesnot fetch the values from the table and is giving SQl code as 100. But that record is there in the table.

Please help.

[kolusu]

omswarup,

You have opened the same question in 2 forums and you sent me a private message and an email?

You need to understand what START/FINISH proc does.

START proc is executed only ONCE at the beginning of the program

FINISH proc is executed only ONCE just before the termination of the program

You need to open and close the cursor for every record you read from the file

Ideally this is how your program should be. This is untested program just from memory

[omswarup]

Thanks a lot Kolusu for the reply , Apologies for posting the same question in two forums.

I had one more clarification , cant we open the cursor only once and then fetch the table for all the policy numbers in the input and close it at the end.

Is it very necessary to open and close the cursor for every fetch?

[kolusu]

[omswarup]