Re: Ordering of result columns

In article <34FE77F1.789F61FE@camelot.eno.ericsson.se>, Lee Wan Ling <wanling@camelot.eno.ericsson.se> writes >Hi there, > I discovered to my horror that in INFORMIX, when I do a select >statement, >the default ordering of result is by the time of insertion of records >and not by the order >of the columns specified unless I explicitly specifying so. Does anyone >know if there's >any configuration environment variables which I can set to order by >column keys by >default so that I don't have to change all my select statements (which >I have thousands of) >to have the order by keyword? > Start adding order by , it is the only way.. >Regards, >Wan-Ling > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care