Results 1 to 2 of 2

Thread: spool in oracle

  1. #1
    Join Date
    Feb 2004
    Posts
    18

    Unanswered: spool in oracle

    These code in oracle:
    SPOOL &3
    SELECT MESSAGE FROM ZUDTB03 WHERE SH_NAME = '&2' ;
    SPOOL OFF
    how to change to db2 code?
    Thanks

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    spool

    put the sql in a file eg test.sql
    execute from command line
    db2 connect to xxx
    db2 -tvsf test.sql > out.file
    out.file will keep all results
    specify -x if header and trailer are not needed
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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