Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    6

    Unanswered: savepoint in shell script

    How can I use savepoint and rollback to savepoint in unix shell script?


    Thanks,
    Kumar

  2. #2
    Join Date
    Apr 2005
    Posts
    6
    Can anybody tell me how can I user savepoint and rollback to savepoint in unix shell script.

    thanks

  3. #3
    Join Date
    Apr 2004
    Posts
    54
    Quote Originally Posted by kumar_r
    Can anybody tell me how can I user savepoint and rollback to savepoint in unix shell script.

    thanks
    [QUOTE]
    #/bin/bash
    db2 -c- connect to <yuordatabase> user <yourlogin> using <password>
    db2 -c- savepoint point1 on rollback retain cursors
    db2 -c- create table x (id int)
    db2 -c- rollback to savepoint point1
    [QUOTE]

Posting Permissions

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