Cursor and SQLCODE=100

Greetings all...

I hope I can describe this problem clearly. I need to make a modification to a program that prints a single page per person requesting this information. Currently , the program will embed a newpage character ('^L') in between persons' records so they print on separate pages. However, the last person's page clearly does not need another newpage character. Additionally, requests are often made one at a time, meaning it is possible that 100 requests are processed, with a blank page following each one. This, you can see, is wasteful.

So... how is this relevant to this newsgroup??? I need to know when FETCH generates a SQLCODE = +100. Is this code set _when_ the last record is FETCHed, or _after_ the last record has been FETCHed and when the next FETCH fails? This is important, because if it happens _afterward_, then it is too late to for me to suppress printing the '^L' (at least, with the current logic.)

Do I need to change my program logic?

I would appreciate any hints.

Cheers,

dan kefford
programmer analyst
fairfield university
dkefford_at_fair1_dot_fairfield_dot_edu

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet