IBM Mainframe Forum

Hi All

We have a requirement where we need to fecth data from more than one table.The table we need to refer will dynamically chnage based on Date in request .We have different tables defined for each date.We need to calculate the date in program and based on the results range we need to call those many Date tables.

Is it possible to declare the same cursor multiple times,each time for differet date to refer to that Date table?

Please tell me if we have any other option

Thank You

Your question is just as (censored) "can we declare the same variable twice, once to hold debits and once to hold credits."

Of course you cannot!

Hello,

But you can declare 2 separate cursors that accomplish the same thing. . .

If you more clearly post more detail about what you want to do, maybe someone will have a more useful suggestion.

Hi,

I guess I understood where are you coming from. You need to have the same cursor function differently for different inputs. Right?

In that case, have you tried declaring the cursor more than once with the same name in the procedure division. The only thing which you will have to make sure of would be that you cannot execute 2 paras, both declaring the same cursor, in the same execution. You will at the time of execution have to make sure which cursor defintion do you want to pick. Be aware, that you can choose only one definition.

Actually what Nik22Dec said, is not true.
DECLARE CURSOR is not an executable statement. it is just a definition you give to the DB2 precompiler, much like DECLARE TABLE.
It is resolved during precompile / bind.
It's like asking to have two (77-level) variables in working storage with the same name (as Prino pointed out).

so you can NOT have :

These users thanked the author GuyC for the post:

Nik22Dec (Thu Jun 21, 2012 5:59 pm)

Now, that's really an embarrasing position to be into. I really need to brush my concepts thoroughly. Sorry All!!!

I figure I comprehended what kind of slant are you taking on this issue. You have to have the same cursor work distinctively for diverse inputs. Isn't that so?

All things considered, have you taken a stab at pronouncing the cursor more than once with the same name in the strategy division. The main thing which you will need to verify would be that you can't execute 2 paras, both pronouncing the same cursor, in the same execution. You will at the time of execution need to verify which cursor defintion would you like to pick. Be mindful, that you can pick stand out definition.

I guess it was figured out almost 3 years ago! Please reply to active topics.