Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    73

    Unanswered: SQL query output to a CSV file

    UDB v8.11

    All-

    How do i send the out put of sql QUERY TO A CSV file. This is an urgent requsst . And any help is appreciated.

    thanks

  2. #2
    Join Date
    Mar 2005
    Posts
    40
    Try this
    Writing to a OutFile from command ine from the c prompt
    db2 -z c:/xxx.xls SELECT * FROM tablename

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by dba_udb
    UDB v8.11

    All-

    How do i send the out put of sql QUERY TO A CSV file. This is an urgent requsst . And any help is appreciated.

    thanks
    Look at the EXPORT command.

    Andy

Posting Permissions

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