User Profile

Collapse

Profile Sidebar

Collapse
Jalaj
Jalaj
Last Activity: Nov 20 '09, 12:44 PM
Joined: Jul 25 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jalaj
    replied to Problem with Update Query in db2 9.5
    in DB2
    Your Query doesnt look ok. I dont think it would run without error.
    Pls try the update as shown below:

    UPDATE SAGE2ADM.TICKET P
    SET TICKETSTATUS = (SELECT STATUS FROM
    SAGE2ADM.STAGE_ EESMPROBLEM_NOR TH S WHERE S.SOURCETABLENA ME=P.SOURCETABL ENAME AND S.PROBLEMNUMBER =P.PROBLEMNUMBE R
    AND S.STATUS<>P.TIC KETSTATUS)
    Where Exists (Select 1 From SAGE2ADM.TICKET T, SAGE2ADM.STAGE_ EESMPROBLEM_NOR TH...
    See more | Go to post

      Leave a comment:

    • Jalaj
      replied to Problem with Update Query in db2 9.5
      in DB2
      The update clause is missing the Where condition for the table TICKET. Pls note that in this case, the entire table will be updated!
      See more | Go to post

        Leave a comment:

      • Jalaj
        replied to MS-SQL queries to DB2 conversion
        in DB2
        You can use the IBM Migration Toolkit
        See more | Go to post

          Leave a comment:

        • Jalaj
          replied to Alter column precision
          in DB2
          Decimal data type can now be altered in v9.1 and above.
          alter table <tablename> alter column <colName> set data type decimal(x,y).
          You can only alter upto 3 columns and then you need to ReOrg the table.
          See more | Go to post

            Leave a comment:

          No activity results to display
          Show More
          Working...