Hi All,

I hava a problem when I use this statement:

SELECT COLNAME , TYPENAME, LENGTH, SCALE, IDENTITY, KEYSEQ FROM SYSCAT.COLUMNS WHERE TABNAME = 'MYTABLE';

using C# to get the list result but sometime The list columns in SYSCAT.COLUMNS of table MYTABLE is in the wrong order.

Can you tell me why and please show the way to get The list columns in right order .

My table like this : F1(PK), F2, F3, F4 ----> and The list columns that I get by C# is: F1, F4, F3, F2.

Please help me.
Thanks and sorry for my poor English.
Rock.

Any time you use SQL and want the rows returned in a specific order, you must use the ORDER BY clause. Even if you don't think you need it, there is no guarantee that the rows will be returned in the same order as a previous execution of a query, unless you have the ORDER BY statement.

Thank you Marcus_A, now I use "ORDER BY COLNO" ---> It works well.

Have a nice day!!!