| View previous topic :: View next topic |
| Author |
Message |
NASCAR9
Intermediate
Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California
|
 Posted: Tue Nov 01, 2005 11:27 am Post subject: Production Job Performance and more |
 |
|
I need to update a table on a weekly basis. This can be accomplished with a query. Here are my questions:
1. What will have better performance DSNTIAUL or a compiled COBOL program?
2. Is DSNTIAUL ok for a production job?
_________________
Thanks,
NASCAR9 |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12401
Topics: 75
Location: San Jose
|
| Posted: Tue Nov 01, 2005 11:30 am Post subject: |
|
|
NASCAR9,
What kind of updates are we talking ?
A single sql statement which would update the entire table or is the update based on a key in the table?
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
NASCAR9
Intermediate
Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California
|
| Posted: Tue Nov 01, 2005 11:36 am Post subject: |
|
|
kolusu,
The query could update 0 to 1000 rows. Here is the query.
| Code: | UPDATE HOURS.PREMACTIVE A
SET (A.ARREARS,
A.ARREARS_DATE) =
(SELECT 'A', B.MAILDATE
FROM HOURS.UFCWLETTER B
WHERE B.MAILDATE = CURRENT DATE
AND B.LETTERNAME = 'PREMLETT101'
AND A.SSNO = B.SSNO
AND A.EMPDATE <> '9999-12-31'
AND A.ACTION <> 'DELETE'
AND (A.ARREARS = ' '
OR A.ARREARS IS NULL))
WHERE 0 NOT IN (SELECT COUNT (*)
FROM HOURS.UFCWLETTER C
WHERE C.MAILDATE = CURRENT DATE
AND C.LETTERNAME = 'PREMLETT101'
AND A.SSNO = C.SSNO
AND A.EMPDATE <> '9999-12-31'
AND A.ACTION <> 'DELETE'
AND (A.ARREARS = ' '
OR A.ARREARS IS NULL)) |
_________________
Thanks,
NASCAR9 |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12401
Topics: 75
Location: San Jose
|
| Posted: Tue Nov 01, 2005 11:57 am Post subject: |
|
|
NASCAR9,
I would prefer a cobol program opening a cursor on table A and B.
Another option is to run an explain for the above update statement and see the cost
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
NASCAR9
Intermediate
Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California
|
| Posted: Tue Nov 01, 2005 12:02 pm Post subject: |
|
|
kolusu,
A batch program is the way I was leaning also.
_________________
Thanks,
NASCAR9 |
|
| Back to top |
|
|
SureshKumar
Intermediate
Joined: 23 Jan 2003
Posts: 211
Topics: 21
|
| Posted: Tue Nov 01, 2005 2:20 pm Post subject: |
|
|
NASCAR9,
Also take into account the activity on the table HOURS.PREMACTIVE, it can cause deadlock/timeout to other processes. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
