Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Kuala Lumpur, Malaysia
    Posts
    1

    Lightbulb Unanswered: unload all columns including the header

    Folks,

    I have a question here. I'd like to unload all rows from a table but when using unload command (as below), it does not include the header name as well (the columns name).

    syntax :

    unload to <filename>
    select * from <tablename>

    alternatively, I tried using select statement to select each column (for a test, table only constst of 3 columns..which is ok). and it does output the column name for each column selected. But, obviously, this is not practical for table with 50 columns for e.g.

    so..anyone can share an idea?

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please test with OUTPUT TO.

    Gustavo.

Posting Permissions

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