How do I update rows in DB2?

828840 pts.
Tags:
DB2 query
IBM DB2
How do I update rows in DB2. When I used SQL, I was able to go forward with this:
update top (100) table1 set field1 = 1
This doesn't work in DB2.  Any suggestions on what I should do instead?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TomLiotta
    Generally, that UPDATE statement doesn't make good sense in SQL even when it is allowed. What is the actual result that you are trying to achieve? It looks as if some information about 'table1' needs to be explained so we know what is expected. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: