|
-
A very simple question
I have a main .sql file from which I call a couple of other .sql files
example
setup_main.sql
@setup_one
@setup_two
@setup_three
so, during our system installation, we just run setup_main.sql. That takes care of all other setups.
Now, my question is, I have some variables that are used in some setup scripts. Is there a way by which I can initialze those variables in setup_main.sql itself and pass them as arguments to the other setup scripts ? Otherwise, the person installing the sofware has to go to each of the setup scripts and change them. I am trying to avoid that.
So, I want my setup_main.sql to look like:
setup_main.sql
@setup_one host_name
@setup_two user_name
@setup_three
I was thinking may be I have to create stored procedures for sqls to access input variables. Is there a better way ?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|