could you clarify?

Reformat, to me, means that you will erase the hard drive.

You're welcome.

Nixon

vstitte (2/4/2010)

---

How much data is there? You could try creating a clustered index on date/month column and then when you load the data for the current month, ensure that the...

What does the udf do that could not be done in a stored proc?

This was perfect timing for me. I was just looking for something to help me with the very topic.

Thanks for the article.

As Arun said, the character...

Drikus Roux (2/4/2010)

---

If you are going to use the LSN to get to the UID (given your application does not impersonate and you don't have roles instead of users etc.)...

:Whistling::laugh:

Are the records being deleted sequential? And the records being loaded, are they sequential?

The delete and reload is fragmenting your clustered index and other indexes. As the table...

I may have misunderstood your first post.

If you want an aggregate of all of the records in the table then:

select itmcod,

sum(isnull(opeqty,0))as opeqty,

sum(isnull(inwqty,0))as inwqty,

sum(isnull(isuqty,0)) as isuqty,

((sum(isnull(opeqty,0))+ sum(isnull(inwqty,0)))-sum(isnull(isuqty,0)))AS CLOSQTY

from ITMLED

group...

Is the table wiped out, or is the DB2 data just added to the existing records in the destination table?

KeyurGohel (2/3/2010)

---

Table: ITMLED

Recsno itmcod opeqty inwqty isuqty

6200 001 500 ...

Thanks for the question.

More than likely not. As Jeff and Elliott said - it seems...