Re[2]: Urgent!!

one possible solutions is to have your scripts set the screen width to something wider than 80. try doing an 'stty -a' from the unix prompt and look for the 'columns ='. try stty cols 132 and run your scripts. _______________________________________________________________________________ Subject: Re: Urgent!! From: mpeter.muc@sni.de@smtpsend at #EMAIL Date: 3/1/96 3:31 AM Apparently-To: RZBJ40@email.sps.mot.com } } > } } > 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) } } Hi, Informix displays the query result in it`s standard editor. If result exceeds the width , then the result will be displayed as you said. I dont have solution thro query. But you can use report generator availiable in the isql menu to generate reports for the for particular table. You can change the report file using standard unix editors to modify according to your requirment. You can change the select if you want joins. You have to change the format section. It looks like format every row end Change this to format on every row print column 5,x,column 10,x2 clipped,... end For more information refer Report writter manual. Goodluck. Bye. Peter e-mail : mpeter.muc@sni.de