How change SO environments by DBACCESS ?
Dynamic Informix asked how to change Unix environment variables inside dbaccess without quitting. Everett Mills said changes to INFORMIXSQLHOSTS or INFORMIXSERVER need a restart, but another server can be reached with the DATABASE name@server statement. Art Kagel confirmed it cannot be done and urged posters to state the real problem.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
How can I change some SO environments without close the dbaccess ?
??? Please more description.
Art S. Kagel
----- Original Message -----
From: Dynamic Informix <ids@iiug.org>
At: 3/05 12:42:50
How can I change some SO environments without close the dbaccess ?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Sorry, I just want know how to change some Environment Variables of Unix without quit the DBACCESS (like Alter Session of Oracle). Thanks.
What are trying to accomplish? If you need to change your
$INFORMIXSQLHOSTS or $INFORMIXSERVER and have it affect your current
session, then no, you must restart dbaccess. If you just want to attach
to a different server, just make sure the other server is available in
you sqlhosts file and use SQL:
database my_other_database@my_other_server
--EEM
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
DYNAMIC INFORMIX
Sent: Monday, March 05, 2007 12:43 PM
To: ids@iiug.org
Subject: Re: How change SO environments by DBACCESS ? [8563]
Sorry,
I just want know how to change some Environment Variables of Unix
without quit
the DBACCESS (like Alter Session of Oracle).
Thanks.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
You cannot, but some of what you may be wanting to do can be done other ways. What is it you want to be able to change? General to the list: PLEASE post your problem. Don't ask how to implement the solution you thought of that you can't make work. It wastes bandwidth and almost never gets you the answer you need on the first try. Art S. Kagel ----- Original Message ----- From: Dynamic Informix <ids@iiug.org> At: 3/05 13:43:47 Sorry, I just want know how to change some Environment Variables of Unix without quit the DBACCESS (like Alter Session of Oracle). Thanks. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.