Hello,
we have migrated our database to IDS 9.21 and work with it via ODBC
SDK 2.81.TC2 and IBM Informix 3.82.
Starting a select statement with an 'order by', i get now an error message 309, if the field i wish to sort is not a primary key.
Is this a known problem or can anyone help us?

Thanks in advance

Hi,

Verify the syntax SQL.
column-name must be in SELECT list

Gustavo.

Dear Gustavo,

certainly the ordered column is in the select list.
The problem is, that the order by only gets a result
if i try it with primary keys or parts of it.
The problem isn't as simple as you believe.
I hope ther exists an other solution.

Greatings from
Monika