473,320 Members | 1,910 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Exception Table

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
3 2011
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Eric Lilja | last post by:
Hello, I'm working with a hash table that is encapsulated in a class. One of its member functions insert() throws an exception if the insertion fails (for example, if the value was already present...
7
by: meaneyedcat | last post by:
When I call addField(), my table appears to be populated correctly with a new row in the table with all the required fields. However, when I call delete row on any new rows that have been created,...
4
by: Gav | last post by:
Hi all, I'm getting an exception that says a column does not exist in a table when it clearly does. I'm using DataGridTextBoxColumns in DataGridTableStyle and setting the correct MappingName,...
0
by: guy | last post by:
i have a method which throws an exception. the thing i dont understand is that the only change between the two versions is a line of code AFTER the one that throws the exception - see code below...
4
by: maricel | last post by:
I have the following base table structure - DDL: CREATE TABLE "ADMINISTRATOR"."T1" ( "C1" INTEGER NOT NULL ) IN "TEST_TS" ; ALTER TABLE "ADMINISTRATOR"."T1" ADD PRIMARY KEY
6
by: lgbjr | last post by:
Hi All, I've posted this question on the ComponentOne news group, but I thought it couldn't hurt to post it here as well, since, I’m assuming, some others out there are using the C1 controls for...
3
by: bobueland | last post by:
Sometimes the best way to understand something is to understand the mechanism behind it. Maybe that is true for exceptions. This is a model I have right now (which probably is wrong) 1. When a...
5
by: Sridhar | last post by:
Hi, I have created a web application. I have a data access dll to interact with database. I added this dll as a reference to the web application. Now let's say if I am calling a function in data...
3
by: technocrat | last post by:
I was runing load and then set integrity with for exception clause, still the statement failed , there are some reecords in the exception table but the actual table is still in check pending...
9
by: Frawls | last post by:
Hi I Am am having problems with a stored Procedure that i wrote. Basically whats happening is that the Stored procedure Runs fine when i EXECUTE it in SQL Query analyzer. But when i debug...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.