Re: Urgent!!

} > Hi there } > } > V have just migrated to Informix 7.1 from Sybase and all our scripts have } > been based on Select which gives the listing in tabular format. } > } > For Eg: } > } > EmpNo Name Sal } > 1 aaa 9000 } > 2 aab 9912 } > 3 aax 9915 } > 4 aaz 9992 } > } > But using Informix I get it as } > } > EmpNo 1 } > Name aaa } > Sal 9000 } > } > EmpNo 2 } > Name aab } > Sal 9000 } > } > } > Is there any way that by default I get in the format as given in 1. ie tabular format? } > } > } > } > } > } Rgds } } Madhavi } } (madhavi@hpbbb89.india.external.hp.com) } The informix editor displays in the result as a column on one line if the result it too wide to fit on the screen. In case u want to store the output and then run some shell scripts , u can possibly unload the data and then use run your scripts on the resultant file. Hope this helps !!! ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 3296 White Plains, NY 10604 | Fax : (914) 682 5236