By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

Exception Table

P: n/a
FM
Good afternoon:

A little question about Exception table:

I want to create an excetion table for rows deleted but only want to
store few rows, 20 for example.

I have searched a lot of documentation but coul not find anything
about it.

Is this possible in DB2 UDB 8.2?

Thanks in advance for your answers.

Mar 13 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Can you be more clear on this question.

swami
On Mar 13, 11:35 pm, "FM" <felix_manr...@yahoo.comwrote:
Good afternoon:

A little question about Exception table:

I want to create an excetion table for rows deleted but only want to
store few rows, 20 for example.

I have searched a lot of documentation but coul not find anything
about it.

Is this possible in DB2 UDB 8.2?

Thanks in advance for your answers.

Mar 14 '07 #2

P: n/a
FM
On Mar 14, 2:57 pm, "swami" <sivaswamim...@gmail.comwrote:
Can you be more clear on this question.

swami

On Mar 13, 11:35 pm, "FM" <felix_manr...@yahoo.comwrote:
Good afternoon:
A little question about Exception table:
I want to create an excetion table for rows deleted but only want to
store few rows, 20 for example.
I have searched a lot of documentation but coul not find anything
about it.
Is this possible in DB2 UDB 8.2?
Thanks in advance for your answers.- Hide quoted text -

- Show quoted text -
Hello:

What i mean is that I want to to execue a Load - Script with "FOR
EXCEPTION" parameter.
But I don't want to have all exception rows stored in it. Only a few,
20 for example.

Tank you.

Mar 14 '07 #3

P: n/a
Ian
FM wrote:
>
What i mean is that I want to to execue a Load - Script with "FOR
EXCEPTION" parameter.
But I don't want to have all exception rows stored in it. Only a few,
20 for example.
Unfortunately, no. It's all or nothing.

With other violations (meaning other than rows deleted during the DELETE
phase), you may be able to use the 'warningcount' and 'dumpfile'
modifiers to capture rejected rows.

Mar 18 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.