can not sort rows

Posted in 1992

clay irving — 21 Aug 92 23:40:27 GMT — source: Informix-list mailing list archive (1991-1998)

We've written a I-4GL program to process an order table contain 17,000 rows. The table is being joined to several other tables. There is a good amount of substring manipulation and temporary tables. We receive a message "Can not sort rows" -- "System error -5". An Informix SE indicated that temporary tables are being built in rootdbs, regardless of the dbspace the working database is in. I added a 100MB chunk to rootdbs and a 150MB chunk to the working dbspace, but I still get the same error message. I hate to keep throwing disk space at the problem until it <hopefully> goes away -- Does anyone have an idea what's going on and a possible solution? ==================================================================== Clay Irving garpac!clay@uu3.psi.com (temporary) Project Mgr clay.irving@execnet.com (personal) Garpac Corp 75170.107@compuserve.com (CIS) ==================================================================== --- ~ WinQwk 2.0 a#480 ~ As easy as 3.1415926535897932384626433832795028841. -- Executive Network Information System (914) 667-4567 International ILink Host