Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    4

    Unanswered: DB2 with Unix Scripting

    I need shell script code for the following

    1. Read syscat.columns after connecting to DB2 using SQL cursor
    2. Read the output of the previous SQL command in the shell script
    3. Perform insertions and deletions in the output of step 1

    Thanks

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    see the update on different thread from yourself
    after the select before the done you can insert/delete.. any operation with the retrieved variables from syscat..
    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
  •