Re: Is there way, i can display query results in c

This is what dbaccess does if the output is wider than 80 characters. Your options are: 1- There's a package in the IIUG Software Repository with a Perl script that can reformat the output. 2- Use unload to a delimited file and post-process the file using awk, Perl, or whatever to get the output format you want. 3- Get Jonathan Leffler's sqlcmd package and use that instead of dbaccess. By default it outputs in delimited format, but there are options for fixed format and others as well. Art S. Kagel ----- Original Message ----- From: Ravi Kumar <ids@iiug.org> At: 3/28 3:03:21 Hello, Below is my requirement. Is there any way i can acheive that? If i fire the query " Select * from customer ", the o/p is like below(display is vertical): Customer_no : 101 Fname : Ravi Lname : Kumar .... .... .... My requirement is to display the results in horizontal way, like below... Customer_no Fname lname ... ------------------ ---------- --------- 101 Ravi kumar 102 Ajay xyz ..... Thanks in advance for all your assistance. Regards, Ravikumar. --------------------------------- Here's a new way to find what you're looking for - Yahoo! Answers ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.