Thomas Steinmaurer wrote:

> Lee,
>
>
>>Is there a way to query the system tables to retrieve the generator (if
>>any) that is being used by that table?
>>--
>
>
> You probably use a generator to increment the value of
> a primary key column for your table, but the generator
> doesn't stand in any relationship to a table.
>
> That means, you can create a generator without having
> any table in your database.

So no way to figure out which generators, if any, a table is using...
Makes sense, given the nature of generators. Hmmm. Maybe I could just
use a separate table and store the values of the generator names there.

I'm thinking about building an import utility that will bulk process
INSERTS into a DB but don't want to get in trouble with the generators
lagging behind cause PK violations.

Lee



--

Warm Regards,

Lee