Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: Run a sql from unix

    i have file Summary.txt

    contents looks like this

    Code:
    ./log_CS-185.lst:Error detected, rollbacking
    ./log_CS-13603.lst:Error detected, rollbacking
    ./log_CS-1002.lst:Error detected, rollbacking
    now i have to parse this file to get
    CS-185
    CS-13603
    CS-1002

    and insert these values into a table... how do i do this using unix script ?..

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    $ awk "
    > BEGIN {print \"connect to mydb\"}
    > {match(\$0,/\/[^.]*\./);f=substr(\$0,RSTART+1,RLENGTH-2); printf \"insert into mytable values ('%s') \n\", f ;}
    > END {print \"commit\"; print \"connect reset\"}
    > " Summary.txt | db2

Posting Permissions

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