Re: Which row is the error in an Insert-Select using on-error

[David Thompson-Hall <david.thompson-hall@DOIT.WISC.EDU>]

At 10:40 PM 6/3/2002 -0700, Mike Lee wrote:
>I'm using the on-error because I would like to capture
>the exact key values that the SQL dies on due to
>constraint violations.

Given that you want to do this with dynamic SQL and without listing all the
columns, I don't see how you can grab specific field values.  The two are
mutually incompatible - unless someone knows a way to pull the contents of
a dynamic query out of SQR...

Is there some important functional reason why you have to use this
"generic" select instead of a specific one, or are you just trying to
reduce maintenance?

Of course, checking for referential integrity violations beforehand will do
the trick too... you could even add a dynamic where clause to preclude
processing those rows in your select statement (I think; I haven't actually
worked this out...)

DTH


David Thompson-Hall                                     1210 W. Dayton St.
Project Leader                                  Madison, WI 53706
Apps Tech/Operational Support Apps                      608/265-9571
Div of Info Technology (DoIT)
University of Wisconsin-Madison david.thompson-hall@doit.wisc.edu