Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. craving94509

    Need a little help with an update trigger (DB2)

    I am hoping someone can help with a DB2 trigger I am trying to write? After update of workorder.status = 'APPR' I would like to update the lr_cpstatus of any records in same table = 'PENDING' where the updated workorder.wonum = workorder.parent and workorder.lr_cpstatus is null and lr_rectype...
  2. craving94509

    Simple Update Takes Hours

    I have a simple update that seems to take a long time (6 hours). I am wondering if anyone can offer a way to speed it up? 350,000 rows with no null values in the source column. The source column is a text field that has values as long as 3900 characters. There are no indexes on the table...
  3. craving94509

    Query to set column values

    Thanks dhookom, I would love to do that but there is an index on the table that does not allow duplicate workorderid's. This field is also required on insert. Since I have multiple Access databases there will be duplicate workorderid's, and that is what I am trying to fix. Maybe if I put it...
  4. craving94509

    Query to set column values

    Some additional information: There is preexisting data in the SQL Server database with existing records. SQL Server select max(workorderid) from workorder returns 100000 Access DB #1 I need to sequentially update the workorderid starting at 100001 (for 230,321 records) Load data into SQL...
  5. craving94509

    Query to set column values

    Hello all, New to the forum and hope someone can help me with an issue that has been driving me crazy. Our company has acquired many different gas processing facilities that all run the same program (Maximo) in stand alone environments on Oracle. Each of these plants has exported there data to...

Part and Inventory Search

Back
Top