Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: How to get output of sql command in columns

    Hi,
    I am working with Informix db in Digital Unix.
    When I try to give any select commands and try to retrieve more than 5 columns in the same sql command, the output comes in rows instead of columns.
    Is there a way to force it to come in columns???

    i just use a simple format,
    select column1 ,column2 ,column3 ,column4 ,column5 from table

  2. #2
    Join Date
    Nov 2004
    Posts
    108
    you should be getting 5 columns per record in the DB

    column1 ,column2 ,column3 ,column4 ,column5
    column1 ,column2 ,column3 ,column4 ,column5
    column1 ,column2 ,column3 ,column4 ,column5
    column1 ,column2 ,column3 ,column4 ,column5
    column1 ,column2 ,column3 ,column4 ,column5

    how do you want the layout and why?
    to err is human ; to really mess things up requires a computer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •