Re: Distinguishing Production vs Other Environments

[Arthur Coniglio <Arthur.CONIGLIO@EDDEPT.WA.EDU.AU>]

Wayne,

Not quite sure about Informix, but within Oracle you can perform a select as
follows:

select  user
from    dual;


Arthur Coniglio
Unisys Information Services
Arthur.Coniglio@Unisys.Com
Ph:  0414 638322

        -----Original Message-----
        From:   Ivory, Wayne [SMTP:wivory@WSL.COM.AU]
        Sent:   Friday, March 26, 1999 3:01 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        Distinguishing Production vs Other Environments

        My first question in quite some time...

        We went live this month with PeopleSoft's HR system.  As we have a
        third-party General Ledger system we have written an SQR to generate
a GL
        interface ascii file which is imported into the other system.  We've
done
        this manually a couple of times and it seems to be working okay, so
I've
        been asked to go the final step and automate the
export/transfer/import
        process.

        We operate several PeopleSoft environments (development, system
testing,
        user testing, production, etc) and two GL environments (test &
production).
        To avoid dangerous on-the-fly code modifications I would like to
write the
        SQR such that it could detect whether it is running in a PeopleSoft
        production environment (and hence transfer to GL production) or in
some
        other PeopleSoft environment (and hence transfer to GL test).

        I was hoping to find an SQR reserved variable that would identify
the
        database name or the server name or something but that doesn't seem
to be
        the case.  The only other thing I could think of is examining an
environment
        variable of some sort.  Alternative suggestions welcome.

        SQR 3
        Informix 7
        SCO Open Server (Unix)


        Wayne Ivory
        Information Services
        Westralian Sands Limited