Re: Urgent!!

Madhavi Rao (madhavi@hpbbb89.india.external.hp.com) wrote: : } : } > : } > : } > : } > 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) : } Yes. There is a way to do it. Try this SQL OUTPUT TO filename WITHOUT HEADINGS SELECT "EmpNo Name Sal", emp_no_col || " " || name_col || " " || sal_col From tab The two pipes above will concatanate the trailing chars and will do the trick! Regards Dhammika