Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: how can I enter some of data from one column to another column of the same table.

    I am working with db2 v7.2 aix 5.2

    Thank you in advance for your help.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    data

    you could use an update statement :
    set col2=col1 for a batch operation
    or use a trigger
    Best Regards, Guy Przytula
    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
  •