12 Replies Latest reply on Sep 27, 2012 7:06 AM by Steven Hawkins

    VDB Initializing Envrionmental Variable

    Bob Akers Newbie

      I'm trying to initialize an environmental variable in a vdb so that a view(s) has access to it when it is launched.  The variable's value is defined by making an sql select.  The idea is to launch this select before launching a view. I've seen things like EXECUTE IMMEDIATELY, etc. but being somewhat new to sql land, wasn't sure how or if I can do this in an 8.1 vdb.  Any help would be appreciated.