Re: sorting to OS filesystem

Posted in 2006

scottishpoet — 20 Mar 2006 08:11:29 -0800 — source: Usenet: comp.databases.informix

have you tried using DBTEMP instead of PSORT_DBTEMP? http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlr.doc/sqlrmst194.htm?resultof=%

↪ replying to scottishpoet

Floyd Wellershaus — Mon, 20 Mar 2006 09:06:51 -0800 (PST) — source: Usenet: comp.databases.informix

Nope, that didn't work. But it caused me to find the issue. It looks like only user Informix is able to successfully implement the PSORT_DBTEMP variable. When I am the application user, and export it, the engine doesn't listen to it. But if I set it as user informix and run my create index statements as user informix, then it sorts in the correct place. I'm not sure if I'm still missing some issue, but for now, at least this will work. Thanks. ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ ----- Original Message ---- From: scottishpoet <dryburghj@yahoo.com> To: informix-list@iiug.org Sent: Monday, March 20, 2006 11:11:29 AM Subject: Re: sorting to OS filesystem have you tried using DBTEMP instead of PSORT_DBTEMP? http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlr.doc/sqlrmst194.htm?resultof=% _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list