what about sql statements within the proc.. them too!!

______________________________
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



-----Original Message-----
From: Serge Rielau [mailto:[Email address protected]
Sent: Wednesday, April 26, 2006 10:07 PM
To: Kaushal, Anand
Subject: Re: stored procedures


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


SET SCHEMA = MYSCHEMA
[Email address protected]
SET PATH = SYSTEM PATH, MYSCHEMA
[Email address protected]
CREATE PROCEDURE ....
[Email address protected]

The procedure will be created in MYSCHEMA. All tables, views, aliases will
be resolved against MYSCHEMA and all procedures, functions, types against
SYS* and MYSCHEMA

Cheers
Serge

"Kaushal Anand " [Email address protected]
wrote on 04/26/2006 12:10:01 PM:

> 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
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>






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