Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
D. Sandmann — — source: Informix-list mailing list archive (1991-1998)
I have a stored procedure that is distributed accross many databases
(development, testing, certification, training and production). The
development and testing db reside on the same box in two different
instances. The certification and training database reside on the same
box on the same instance. The production database resides on its own
system and instance.
The stored procedure makes a system call that runs a shell script which
then calls a 4GL program to generate a report.
I would like the stored procedure to tell my shell script which
database/instance it is being called from. Based on that information the
shell would then know what environment variables to set up and what 4gl
program to call.
I do not want to hardcode that information into the stored procedure
because we sometimes take a snapshot of the production database and
place the snapshot on the other databases.
Any help!!
Thanks in advance,
David S.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.