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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.