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: *
- Users: craving94509
- Content: Threads
- Order by date
-
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...- craving94509
- Thread
- Replies: 0
- Forum: IBM: DB2
-
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...- craving94509
- Thread
- Replies: 7
- Forum: Oracle: All versions
-
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...- craving94509
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
