Thanks - quick cursor question

Melissa Rogers

Thanks - quick cursor question
Just wanted to say thanks to all of those who responded. I was able to use
an unqualified table name in my declare statement. During the precompile
process, I received warning messages stating that the table was undeclared
however the job did run successfully. thanks

-----Original Message-----
From: James Kwan [mailto:[login to unmask email]
Sent: Friday, December 14, 2001 2:16 PM
To: [login to unmask email]
Subject: Re: quick cursor question


In a message dated 12/14/01 11:32:24 AM Central Standard Time,
[login to unmask email] writes:




When declaring a cursor, does the cursor name have to be fully qualified?
Our object qualifier is just a label not an userid. We are using the bind
qualifier option to qualify our table names but I seem to get a compile
error if I exclude the qualifier in the declare statement. Any ideas??
thanks!




No, you don't have to qualifier you objects. A compiler error or a
precompiler error?

James Kwan
IBM Certified Specialist