Re: SET EXPLAIN question

richard_thomas@yes.optus.com.au ("Richard Thomas") wrote: :CONNECT TRIGGERS : :I would really like to be able to centralise configuration issues within = :the engine itself. Our installation is a big (>200Gb) warehouse, and = :every program has to set isolation levels, PDQ resources and lock modes, = :because the (in our case inapprioriate) defaults are not = :site-configurable. This is done at the application level (ESQL/C, = :ESQL/COBOL, 4GL, DBACCCESS) etc, and requires the user knowing and = :_remembering_ to do it (especially problematic in ad-hoc DBACCESS) : :Wouldn't it be nice to make this global and automatic with a CONNECT = :TRIGGER? Functionality like that would make the SET ROLE statement a lot = :more useful also! : :I'm sure others could see a use for this, and I'm not redirecting my = :output to /dev/null... :) This is some of the functionallity you get with the OpenLink ODBC drivers. It's such an obvious feature I hardly understand why it isn't allready in there. I hope Informix will put it on there list if they haven't allready. Of course this shouldn't be system wide only. It should be possible to execute any set of sql statements at connect time based at least on the following (to the extent the information available): 1. Username 2. Terminal ID (port name with Unix serial terminals, machine name when using TCP/IP connections or other solutions) 3. Program name (For programs running on the server it shouldn't be hard to send the programname to the engine. I-Connect should implement it for programs running on a client.) For this to be realy usefull there should of course be a simple graphical administration program where all these parameters for currently connected users was displayed and one could put in options for these and every other username, terminal id and program name. I realize this would require some possibly significant changes in the connection libraries and other software Informix supplies. However both the ability to set all kinds of parameters and the added level of security one could achieve would be such a significant advantage that it should be done. I don't think this is available from any of the competitors, and as soon as people realize what they can do with it the selling point for Informix wouldn't be a minor one. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org