Post reply

Using SQL Server 2000 SP3 to Update IBM DB2 UDB 7.2

  • January 5, 2006 at 7:08 pm

    #91163

    Can anyone help me use SQL Server 2000 SP3 to UPDATE IBM DB2 UDB 7.2? SELECTs work fine, but UPDATEs don't work.

    Thanks in advance.

    Jon

  • January 9, 2006 at 2:47 am

    #613485

    Have you checked the obvious...

    1) Do you have UPDATE rights on the DB2 database.

    2) Is your syntax DB2 compliant.  DB2 and SQL Server have a very similar SQL dialect, but DB2 insists on quoted identifiers whereas SQL Server can use quotes or [].  The WITH clause for hints is not known to DB2, etc.

     

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • January 9, 2006 at 12:21 pm

    #613654

    and to add a bit more ...

    UPDATE FROM is not supported by DB2 that's a MS extension

    Cheers,

     


    * Noel

  • January 10, 2006 at 1:07 pm

    #613914

    Does the driver handle conversion of any numeric fields or does this need to be done in the update query?  I believe DB2 stores everything as a string correct?

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply