Hi,
Scenario: I am designing a shared container. In this container, I am inserting few rows into a DB2 table (lets say X). Later in this container, I have to extract same table (X) which should contain the inserted rows also.
Question: How do I do this?
Thanks
Read from a DB@
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
When updating the table (for firsttime) I have a user defined SQL. In the after tab of the SQL I am commiting the recoded. I am doing a sparce lookup later in that stage. but the problem is, that the job is running so fast (with 82,000 records) that it is doing the lookup even before commiting. I am not able to contol the speed of execution.
This problem is still open to me
This problem is still open to me
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Messy. To get a commit to happen on every row just set the transaction and array sizes to 1. They are optional options on most parallel DB stages and default at 1000. That way you can be sure the row is in the database before you query it.
I assume you are doing this to retrieve a generated sequence number back from the database.
I assume you are doing this to retrieve a generated sequence number back from the database.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA