Setting PSORT_DBTEMP in INFORMIX 7.31

Hellooooo Informix Users,=20 =20 If I set the environment variable PSORT_DBTEMP on my Unix server which hosts my IDS before bringing the engine online, will it be in effect for each session that requires sorting=3F Further more will it also be in effect for sessions initiated from different client application servers=3F =20 =20 Client: Informix Client SDK 2.7 OS - Window 2000 Advance Server =20 Database: IDS ver - Informix 7.31.UC5 OS - HP-UX 11.0 b Server: HP 9000 N-Class This email may contain material that is confidential, privileged and/or = attorney work product for the sole use of the intended recipient. Any review= ,= reliance or distribution by others or forwarding without express permission = is strictly prohibited. If you are not the intended recipient, please contac= t= the sender and delete all copies. Latham & Watkins LLP

As far as I know, PSORT_DBTEMP is set in the user's environment, not the engine's environment. In UNIX, it's just a matter of including it in the .profile, but I'm not sure about a client/server environment. -----Original Message----- From: Anthony.Oje.... [mailto:Anthony.Ojeda@LW.com] Sent: Thursday, September 25, 2003 12:47 AM To: ids@iiug.org Subject: Setting PSORT_DBTEMP in INFORMIX 7.31 [1923] Hellooooo Informix Users,=20 =20 If I set the environment variable PSORT_DBTEMP on my Unix server which hosts my IDS before bringing the engine online, will it be in effect for each session that requires sorting=3F Further more will it also be in effect for sessions initiated from different client application servers=3F =20 =20 Client: Informix Client SDK 2.7 OS - Window 2000 Advance Server =20 Database: IDS ver - Informix 7.31.UC5 OS - HP-UX 11.0 b Server: HP 9000 N-Class This email may contain material that is confidential, privileged and/or = attorney work product for the sole use of the intended recipient. Any review= ,= reliance or distribution by others or forwarding without express permission = is strictly prohibited. If you are not the intended recipient, please contac= t= the sender and delete all copies. Latham & Watkins LLP "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."