RE: SE 7.2 , Sorted rows problem

Posted in 2001

John Carlson — Thu, 8 Feb 2001 13:37:58 -0500 — source: Informix-list mailing list archive (1991-1998)

What are the permissions on the directory? BTW, I've used PSORT_DBTEMP to do sorting to filesystems. Is your variable correct? John Carlson Informix Database Administrator EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330 -----Original Message----- From: sathish_sadagopan@my-deja.com [mailto:sathish_sadagopan@my-deja.com] Sent: Thursday, February 08, 2001 11:00 AM To: informix-list@iiug.org Subject: SE 7.2 , Sorted rows problem Hi, When I run a query thro' an application in VB or COBOL , I get a -567 "Cannot write sorted rows" error. The query is a select statement retrieving a large number of rows . I set DBTEMP in my env. to "/tmp" or some other directory on a file system which has space and permissions , still I get this error. However , I do not get this error if I run the application as "root". I do not get this error if I run the query in DBACCESS as any user or root. Any thoughts ????? SE 7.2 running on ScoUnix Ver5.02. TIA, Sathish. Sent via Deja.com http://www.deja.com/