Re: How to do REFFLD with DDL

Thanks for this Brian,

I can't pur the identity column in the reference file as it is a DDS file. I
tried creating the table as a result from 2 tables,

eg create table T as ( select id from SQLtable, name from DDSfile)

But the column id loses its identity.

In the end I added the Identity column manually.

Just one problem : this page :
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.
db2.udb.doc/admin/c0004994.htm it says I can't do that, but it seems I have
already. What have I missed?

Now, I have discovered sequences. Using a sequence instead of an identity
lets me forget the identity column that I can't put in the DDS reference
file.


From: "Brian Johnson" <brian.johnson.mn@xxxxxxxxx>

Column defined in "field reference table":

create table ref-table-name ...
primary_key_oid for pk_oid integer not null generated always
as identity
(cycle) ...



Column defined in a table using the reference table:

create table table-name
( priKey , ... )
as ( select primary_key_oid , ...
from ref-table-name )
definition only
including identity column attributes
including column defaults