while compiling procedure, or when querying data we are supposed to specify the schema. lets say my current schema is schema1. now what i'd like to do is compile stored procedures without specifying a schema, probably setting some environment variable or registry variable and the schema name being taken from there. is that possible?? the reason i want to do that is maybe the schema name maybe changed in the future.

______________________________
Anand Kaushal
Software Engineer - Database

Lionbridge
5th Floor, Spectra Building,
Hiranandani Business Park,
Powai, Mumbai - 400 076
+91-22-55567000x7079 (office)
+91-9819210090 (mobile)
www.lionbridge.com



DB2 & UDB email list listserv db2-l LazyDBA home page