Re: identity/automatic increment with DDS

A few years ago, IBM announced that it would no longer be enhancing DDS,
and that all new features and functions in DB2 would be made available only
through SQL DDL (and DML).

----- Original Message -----
From: "Yivi" <nardus@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <MIDRANGE-L@xxxxxxxxxxxx>
Sent: Tuesday, December 13, 2005 5:01 AM
Subject: identity/automatic increment with DDS


Hello everyone. Hoping this is the right list for this question...

Is it possible to create a table with an automatically generated column (an
'identity' in DB2, autonum or auto_increment in different DBs) using DDS, or
I can only create it using SQL?

E.g, having this SQL query, would it exist an DDS equivalent?
CREATE TABLE ivan/ALFVISCL7
(
id BIGINT GENERATED ALWAYS AS IDENTITY
     (START WITH 1, INCREMENT BY 1 MINVALUE 1 NO MAXVALUE NO CYCLE NO ORDER
CACHE 20)
     not null,
textito VARCHAR(30)
);

Thanks for any info, and regards.

I.-