Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Unanswered: Script Batch to make a select command

    Hi,

    i'd like create by a batch file a king of query, for example :

    select "filed A" from "Table1" where "filed A" = 'Pippo' > filelog.log


    Is it possible ?

  2. #2
    Join Date
    Sep 2002
    Posts
    456
    Yes, it is possible!

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    batch

    or you can execute directly
    db2 "select .... > filename
    or create a file with the sql statements and execute it with
    db2 -tvf filename > filename_out
    specifying -x would remove the headers and trailer (just keeping data)
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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