[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR Commit problem with DB2
- Subject: [sqr-users] SQR Commit problem with DB2
- From: "Ben L Stevens" <ps_benj@yahoo.com>
- Date: Wed, 29 Sep 2004 09:52:19 -0500
- Delivery-date: Wed, 29 Sep 2004 09:57:42 -0500
- In-reply-to: <22FD466B13E3564BABA4D60EFAC1C42305BCE33A@USCSCMSC8.na.entroot.biz>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcSiS60ULl8sl1lRSkum3YdJMkFcqgCVWHIAAGShXsA=
SQR commit problem with DB2
PeopleTools 8.45.03
I have an SQR with the following logic:
Process-Main
begin-select
TABLE1.FIELD1
TABLE1.FIELD2
TABLE1.FIELD3
....
DO Calculate-some-variables
Do insert-a-row-in-another-table
let #rcounter = #rcounter + 1
if #rcounter > 999
commit (or do commit-transaction)
end-if
from TABLE1
end-select
I have to process over 2MM rows from the select.
The problem is, after the COMMIT, the select SQL starts over at row 1.
I've tried placing the commit in the insert-a-row-in-another-table
procedure, same problem.
I'm using DB2 8.1 FP4 on AIX 64
Suggestions welcome, thanks.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users