User Profile

Collapse

Profile Sidebar

Collapse
satyajit911
satyajit911
Last Activity: Sep 24 '08, 10:33 AM
Joined: Aug 14 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • satyajit911
    started a topic Mass Updation of Records
    in DB2

    Mass Updation of Records

    Hello,

    I have to mass update 40000 records using SQL. But, this operation locks the table for some while. Can anyone suggest how I can update these records part by part say 500 records at a time.

    Thanks,
    Satya.
    See more | Go to post
    • satyajit911
      started a topic DB2 UDB Objects Dependent on UDF
      in DB2

      DB2 UDB Objects Dependent on UDF

      Hi,

      Can anyone please provide me information on how we can check which database objects(views, indexes, etc.) are dependent on a UDF.

      I want to drop a particular function & recreate a new one. Dropping the function will deactivate all the objects dependent on that particular function.

      Any light on this will be highly appreciated.

      Regards,
      Satyajit.
      See more | Go to post
      No activity results to display
      Show More
      Working...