Monday, February 23, 2009

How to solve error "Informix -567: Cannot write sorted rows"?

Try to get the related ISAM error (Follow this for JDBC). If it is "2: No such file or directory", look for your DBSPACETEMP or PSORT_DBTEMP value (via onstat -g env or onstat -c). Ensure the folder points by DBSPACETEMP or PSORT_DBTEMP exists.