1
  • How do I update rows in 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?

    ITKE342,450 pointsBadges:
  • What are the possible situations where DB2 server FORCES to close the applications connected to it?

    Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !

    Saimadhu455 pointsBadges:
  • DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.

    The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate='01-JAN-07' WHERE username='XYZ' Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and...

    Saimadhu455 pointsBadges:
1

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following