Re: What is logged on insert on identity columns?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 27 Jun 2006 07:24:58 -0400
Message-ID: <5KWdnRFmkdYQiDzZnZ2dnUVZ_oydnZ2d@comcast.com>

"Bernard Dhooghe" <dhoogheb_at_yahoo.com> wrote in message news:1151406511.199029.282520_at_i40g2000cwc.googlegroups.com...
: Suppose a table defined as:
:
: CREATE TABLE "MYSCHEMA"."T1" (
: "ID1" DECIMAL(8,0) NOT NULL GENERATED ALWAYS AS
: IDENTITY (
: START WITH +1
: INCREMENT BY +1
: MINVALUE +1
: MAXVALUE +99999999
: NO CYCLE
: CACHE 20
: NO ORDER ) )
: DATA CAPTURE CHANGES
: IN "USERSPACE1" ;
:
: db2 insert into myschema.t1 values (default).
:
: Is the real value inserted in the table logged and is it possible to
: retrieve it with the log analyis API?
:
: Bernard Dhooghe
:

you might want to post this to the SQL Server newsgroup -- this doesn't look like an Oracle question

++ mcs Received on Tue Jun 27 2006 - 06:24:58 CDT