[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Database Name
- Subject: Re: Database Name
- From: danian liu <dliu@UHC.COM>
- Date: Fri, 15 Nov 1996 15:12:04 -0600
- In-Reply-To: <c=US%a=_%p=The_Circle_K_Cor%l=CIRCLEK/EXCH1/0000A0E1@CK_SVC_EXCH_1.circlek.com> from "Lodewyck, Joe-CKCTS" at Nov 15, 96 01:23:00 pm
> Does anyone know how to print the name of the database referenced in the
> USE statement on a report?
We are using Sybase for our project. Our solution to this problem is: we
maintain a single script that gets the environment settings (including DB
information) every time the script/program is run. The DB Name, in turn,
is passed to the program via the command line parameter.
This way, training and development environments are separated from each other
and the overhead for retrieving the DB info is minimal and painless.
It is also DB-independent, something we make every effort to be.
Hope this suits your environment.
danian liu
dliu@uhc.com
--
It is easier to change the specification to fit the program than vice versa.