I am having a strange issue with an informix database. When I try
running some querries (through) cli library it gives me an error saying "Could
not write sorted data". I cant run that querry by hand either.
It shows an error "2: could not find file or directory".
one of the querries is "select * from <table name> where uid = <some number> order
by record_number". (It does work for some other uids, and fails for some others
too.). I tried replacing * by individual field names and it still fails. When I
remove the order by clause, it starts working.
Also, when I remove the largest field from the projection list (like notes, description etc), it starts working. I think there is some memory issue or somethin.